2306097 - Date Format incorrect in report download XLSX

SAP Knowledge Base Article - Public

2306097 - Date Format incorrect in report download XLSX

Symptom

Report Date in UK format as downloaded, but whenever the user change the date, it changes to US format i.e. MM/DD/YYYY.

Reproducing the Issue

You download ORD report as XLSX with UK date format DD/MM/YYYY, Right click on the date cell > Format Cell >  Locate (location) English (US)

Now change the date in the cell / example 31/12/9999 to 10/12/2016 - type enter - the date default  to US format : 12/10/2016

Cause

The Excel default date format is US MM/DD/YYYY, whenever you make change even though the date was in UK format will change to US format.

Resolution

In XLSX downloaded file:
- Right click on cell to change the date format to English United Kingdom
- Go to Excel menu > Data > Text to Column > click next until you get the date > select Date > DMY format and save.
- All change will default to UK format.

Keywords

EXcel default date format Date Format US date format , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem

Product

SAP SuccessFactors HCM Core 1602