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, YouCalc, ORD) , Problem
Product
SAP SuccessFactors HCM Core 1602