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

Inconsistent date value format



When exporting a report definition with a date property to an Excel file, the date value format is inconsistent in the date property column.

Error Messages

Not Applicable

Steps to Reproduce

  1. Open the report definition rule
  2. Export the rule to Excel

Root Cause

Excel is linked to the Pega application with the English-US time format. Excel misinterprets values from the application when the time format of the system (English-US) is set to a different format.


Perform the following local-change:
  1. Click the gear icon for the date property column in the report definition 
  2. Set the column format to pxDateTime
  3. Open the format
  4. Set Type as Date
  5. Set Format as 01/01/2001


Published January 5, 2019 - 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?

Want to help us improve this content?

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
Contact us