SAP Knowledge Base Article - Public

2288908 - How to change the format of Date fields in EC reports

Symptom

In Ad Hoc reporting, a date field is displayed as MM/DD/YYYY.

Example: December 31, 2000 is displayed as 12/31/2000.

 

How do we change this to DD/MM/YYYY?

Environment

SAP SuccessFactors Employee Central

Resolution

When Ad Hoc reports are displayed in Preview, they will always display in MM/DD/YYYY format.

 

However, the Downloaded CSV results can be modified by doing the following:

For the Logged in user:

  1. Click the pull down next to your username on the top-right
  2. Select "Options"
  3. Select "Change Language"

 

Example of the CSV using (English US):

en_USformat.png

 

Example of CSV using (English UK):

en_GBformat.png

 

 

*Note: Some date fields which are based on legacy datasources may only operate in en_us format.

 

 

Keywords

KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , How To

Product

SAP SuccessFactors HCM Core 1511