SAP Knowledge Base Article - Public

2516983 - Date Format of Ad Hoc Report Appears Differently to the UI


In the UI, the date appears as 01/01/2017. When we run ad hoc reports, the dates appear as 1/1/2017


Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 


Employee Central – Ad Hoc Reports

Reproducing the Issue

As of 1708

  1. Reporting
  2. New
  3. Report – Table
  4. Single Domain
  5. Choose Any Type of Ad Hoc Report i.e. Person and employment as of date
  6. Choose date fields
  7. Observe the difference in dates


  1. Reports
  2. Analytics
  3. Choose any type of ad hoc report
  4. Choose any date fields
  5. Observe issue


The date format for the language English US causes this.

If your logged in user or your default locale is English US, once you export an ad hoc report, the dates will appear this way.

The dates also appear the same way if choosing filters

This is due predefined formats of the JAVA programming language

SuccessFactors is built upon JAVA

The Date Format for the US in JAVA will appear as 1/1/2019

See the oracle documentation for further info Here  and Jam




If you need the date to appear as 01/01/2017, then you can change the language of the logged in user to be English_UK

In JAVA, English UK date format appears as 01/01/2017


To do so, go to Options > Change Language > Choose English UK and Click Switch

If English UK is not enabled in your instance, contact your partner or contact SAP support for them to enable the language for you

To complete tasks in Provisioning,

Please contact Employee Central Support Engineer Team and provide the Following:

  1. Customer must provide a written approval for Back end change
  2. Add this to your case :Enabled English UK 

@Employee Central Product Support: See internal memo for further guidance


Ad Hoc Reporting, Date Format, English US, Default Locale, Language,ECT-72764 , ECT-72119 , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , Problem


SAP SuccessFactors Employee Central all versions