Jim Posted March 28 Share Posted March 28 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? Link to comment Share on other sites More sharing options...
Jim Posted March 28 Author Share Posted March 28 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 Link to comment Share on other sites More sharing options...
Steve Giller Posted March 28 Share Posted March 28 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. Link to comment Share on other sites More sharing options...
Jim Posted March 28 Author Share Posted March 28 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? Link to comment Share on other sites More sharing options...
Jim Posted March 29 Author Share Posted March 29 Hi, is their anyway to do the above? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now