2437003 - Month function in Online Report Designer's calculated column not working as expected.

The 'Month' function available in Online Report Designer's (ORD) calculated columns, fetches incorrect results.

SuccessFactors Online Report Designer

1. Create a new query or add a new components in a report in ORD.
2. Add date columns to the report.
3. Create a new calculated column and use the date fucntion in it.
4. 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).
   Example: 
   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.

ORD:
How to identify and change the user locale in Online Report Designer?
2437002

BizX:
How to pre-configure and set a user's default Language
2269940

How to Set the Default Locale for New Users added to an instance?
2395445

LMS:
mass update or mass change of date pattern preference for all users
2261626

Bizx locale change not reflected in LMS - LMS / BIZX Integration
2401516

Online Report Designer month function
Date format mismatch , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors Learning 1702