Symptom
Date Format MM/DD/YYYY is dropping off the leading zeroes when exported to csv, xls, and xlsx.
Environment
SuccessFactors Workforce Analytics
Advanced Reporting
Resolution
In general, it is not possible to keep the leading zero when exporting reports but a workaround can be done for CSV.
- To do this, create a calculated column that is of date datatype
- Add value = the date field.
- Click on edit format
- Check the checkbox 'Use Custom Format'
- Put "MM/dd/yyyy/" in Custom Format String then click on OK
Note that this is only a workaround for CSV and it is not possible when opening the reports in xls and xlsx.
If you open the report in notepad, you will see that zeros are available. This means that SuccessFactors keeps the zero values but Excel drops them when opening the report. This is a limitation and expected behavior of Microsoft Excel, and is a 3rd party issue. Please refer to Microsoft Support if further assistance is needed.
See Also
2582788 - When exporting Learning reports to CSV, leading 0s in IDs are missing
2328644 - Analytics user bulk upload ignores leading zeroes in SF User ID
External Resource:
Keywords
zero in date column, zero, 0, zero in report, export leading zero, zero in report output, 0 in date, leading zero is removed, incorrect date format , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem