The 'Month' function available in Online Report Designer's (ORD) calculated columns, fetches incorrect results.
SuccessFactors Online Report Designer
Reproducing the Issue
- Create a new query or add a new components in a report in ORD.
- Add date columns to the report.
- Create a new calculated column and use the date fucntion in it.
- The Month function fetches incorrect values.
On further inspection, it can be observed that the date (dd) is being used in place of the month (mm).
Date in the data source : 10/2/2016 (MM/DD/YYY)
Expected value from a month function: 10
Actual output: 2
Different languages / locales have different date formats.
Difference in locale’s between BizX and /or LMS and ORD for the logged in user, results in such behaviour.
Different date formats:
mm/dd/yyyy (ex: EN-US)
dd/mm/yyyy (ex: EN-UK)
yyyy/mm/dd (ex: FR-CA)
For non-LMS reports, the logged in user’s local should be the same in ORD and in BizX.
For LMS reports, the local in LMS also has to match the above locale.
The following articles explain how the locales of users can be identified and changed in the 3 systems.
How to identify and change the user locale in Online Report Designer?
How to pre-configure and set a user's default Language
How to Set the Default Locale for New Users added to an instance?
mass update or mass change of date pattern preference for all users
Bizx locale change not reflected in LMS - LMS / BIZX Integration
Online Report Designer month function
Date format mismatch , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem