Support Article
Quarterly report displays four months data for CST time zone
SA-38147
Summary
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
- Set the time zone to CST (observe the data displayed is for the months of Sept, Oct, Nov, and Dec).
- 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.
Resolution
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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.