SAP Knowledge Base Article - Public

3026209 - Is it possible to keep the leading zero of a date column in Advanced Reporting when exporting to excel?


Date Format MM/DD/YYYY is dropping off the leading zeroes when exported to csv, xls, and xlsx.


SuccessFactors Workforce Analytics

Advanced Reporting


In general, it is not possible to keep the leading zero when exporting reports but a workaround can be done for CSV.

  1. To do this, create a calculated column that is of date datatype
  2. Add value = the date field.
  3. Click on edit format 
  4. Check the checkbox 'Use Custom Format'
  5. 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

2074122 - Data Import & Export: How do I open my User Directory in Excel without losing leading zero's in userids, assignment IDs or usernames?

External Resource:

Microsoft Support

Leading zeros in Excel: how to add, remove and hide


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


SAP SuccessFactors HXM Core 2011