Jump to content

Report Time Zone - SQL Schema Designer Reports

Will J Douglas

Recommended Posts


I created a "user last logged on" report which is a SQL Schema Designer report.

The report seems to be using the raw data which is in UTC time rather than adjusting to my timezone which is GMT+4



This logon was actually 9am.

Previous "entity" reports I have created do adjust to the correct timezone.




Link to comment
Share on other sites

  • Senior Member
  • Supportworks Users
  •  37
  • 191 posts

Hi support

when i look at my reports created with advanced Analytics "Last Modified Date" see screenshot and i compare it to the view in My Projects i have always a time difference from 2h

why is that and what can i do? I think it has something to do with the GMT time and the GUI.

Best regards




My Project View:



Link to comment
Share on other sites

  • 2 weeks later...

@Will J Douglas the reports only use raw data when displaying the report preview. When building the report files (CSV, PDF, etc.) the report will convert date/time values based on regional system settings:


Reports do not use the regional settings for users because once generated they become static entities therefore unable to convert the date/time.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...