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 in MM/DD/YYYY format displays in GMT format in Excel file



Date in MM/DD/YYYY format displays in the GMT format in the exported Excel file.

Error Messages

Not Applicable.

Steps to Reproduce

  1. Log in to the application
  2. Create a repeating grid layout with columns with date type properties
  3. Export the contents of the repeating grid to Excel

Root Cause

The date format displayed on the screen is different from what is saved in the Clipboard. Pega always stores dates in GMT format internally. Hence, when exporting to Excel, the GMT date format is passed to Excel.


Perform the following local-change:
  1. Convert the GMT date format to the desired date format using the @FormatDateTime function
  2. Hold the converted date in a Text property
  3. Pass this Text property to the Excel file

Published September 20, 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?

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