Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Export to Excel Date format incorrect

SA-58057

Summary



When exporting a report to Excel, the Date format is different in the exported Excel file.

For example,

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.



Error Messages



Not Applicable


Steps to Reproduce

  1. In the report definition for DateTime column, set the custom format as dd/MM/yy HH:mm:ss.
  2. Run the report. The results display in the correct format. 
  3. Export the data to Excel. 
  4. Open the exported Excel. Verify the format.


Root Cause



This behavior is as per Pega product design.


Resolution



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.


 

Published August 24, 2018 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice