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

SA-63071

Summary



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.


Resolution

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
 
​​​​​​​
Suggest Edit

Published September 20, 2018 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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