Jim Posted March 28, 2023 Posted March 28, 2023 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 Posted March 28, 2023 Author Posted March 28, 2023 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 Posted March 28, 2023 Posted March 28, 2023 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 Posted March 28, 2023 Author Posted March 28, 2023 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?
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