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

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

Pre-1708

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

Example:

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