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

Date format in Excel different from format in report definition



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

Error Messages

Not Applicable

Steps to Reproduce

  1. Launch the Manager portal.
  2. Select the report to run.
  3. Provide the filter conditions if required.
  4. Click Submit. Check the  Date fields and the format (DD/MM/YYYY).
  5. Navigate to Actions.
  6. Click Export to Excel. The format of the Date field in the Excel sheet is different from the report definition.

Root Cause

According to Pega, when the default out-of-the-box DateTime format is provided in the report definition and exported to Excel, the Excel changes the Date format to the system Date format.


Perform the following local- change:
  1. Use the below code to generate the custom control DateTtime format.
  2. Apply HFix-41497.

Published March 21, 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