When running reports using the Trend chart, results based on time may be incorrect due to the 1 hour difference between Daylight Saving Time and Standard Time. This error affects items that are created between the hours of 11:00PM and 1:00AM.

For example, if you want to see all incidents that occured during the previous month, and the previous month was May, all incidents that were recorded between 11:00PM and 12:00AM on the last day of the month would be ignored because the system uses Standard Time. The items would be considered to be part of the month of June.

The issue stems from the fact that records within the SQL database are stored in UTC (Coordinated Universal Time).  UTC does not account for DST (Daylight Savings Time). Records are grouped hourly which causes a discrepancy of an hour during the time shift.  The combination of UTC and the hourly groupings creates the observed behavior of reports being off by an hour.


There is no workaround for this Known Error at this time.


Related Problem: PRB159530

Seen In

Aspen Patch 10
Aspen Patch 2
Aspen Patch 5
Aspen Patch 6
Aspen Patch 8
Berlin Hot Fix 2
Berlin Hot Fix 4
Berlin Hot Fix 5
Berlin Patch 11
Berlin Patch 4
Berlin Patch 5 Hot Fix 1
Berlin Patch 6
Berlin Patch 8 Hot Fix 1
Calgary Patch 1
Calgary Patch 2
Calgary Patch 2 Hot Fix 12
Calgary Patch 2 Hot Fix 5
Calgary Patch 4
June 2011 Release Patch 3

Fixed In

Dublin EA 0

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2016-03-18 09:56:02