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

SAP Knowledge Base Article - Public

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

Symptom

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

Environment

SuccessFactors Online Report Designer

Reproducing the Issue

  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

Cause

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)

Resolution

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

Keywords

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

Product

SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors Learning 1702