British Summer time

[Jim]

Hi all, 

Probably a really easy one but I can't find it under daylight saving or british summer time etc, I have noticed our system is still showing an hour behind on any actions when reporting on them, How do I change service manger to daylight saving mode?

[Jim]

It seems when I log a call the dates and times are accurate but the h_buz_activities.h_updated field is displaying with the time 1 hour behind 

[Steve Giller]

All database values are stored as UTC, if you are reporting on the raw database fields you will always return UTC times.

In the UI these are automatically adjusted based on the User's preferences when viewing a Request.

[Jim]

1 hour ago, Steve Giller said:

All database values are stored as UTC, if you are reporting on the raw database fields you will always return UTC times.

In the UI these are automatically adjusted based on the User's preferences when viewing a Request.

Hi Steve, 

 

This makes sense but how do we allow for this in reporting, I wanted to check work done in the last hour and it returned null. I have a date time picker in the report and returning the  h_buz_activities.h_updated field as UTC, is this something we should just let people know only returns in UTC? 

[Jim]

Hi, is their anyway to do the above?