Export to Excel Date format incorrect
When exporting a report to Excel, the Date format is different in the exported Excel file.
The DateTime format displayed when the report is run is 11/04/18 06:42:08. This is the correct format.
The DateTime format in the exported Excel is 4/11/2018 6:42 AM.
Steps to Reproduce
- In the report definition for DateTime column, set the custom format as dd/MM/yy HH:mm:ss.
- Run the report. The results display in the correct format.
- Export the data to Excel.
- Open the exported Excel. Verify the format.
This behavior is as per Pega product design.
Here’s the explanation for the reported behavior.
Column of Date or DateTime type is exported to Excel with the current Pega Operator locale format. As a result, Excel can parse and treat the column as a Date or a DateTime column. Therefore, sorting and filtering can be performed accordingly.