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

Quarterly report displays four months data for CST time zone



On setting the time zone to CST, the quarterly report displays data for four months; however, this behavior is not observed when the time zone is set to GMT.

Error Messages

Not Applicable

Steps to Reproduce

  1. Set the time zone to CST (observe the data displayed is for the months of Sept, Oct, Nov, and Dec).
  2. Set the time zone to GMT (observe the data displayed is for the months Oct, Nov, and Dec).

Root Cause

The DateTime fields in the database are stored in GMT format. the DateTime field with CST time zone localized the date values displayed on the chart.

For example, records between 01/01/2017 00:00 - 01/01/2017 05:59 are displayed as 12/31/2016 18:00 - 12/31/2016 23:59 and the localized month for those records was 12/2016.


Refactor the filter section to accept the DateTime field instead of the Date field and generate the dates manually using logic. Ensure that the DateTime property values are set based on the current operator’s time zone.

Published October 23, 2017 - 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