Jump to content
Will J Douglas

Report Time Zone - SQL Schema Designer Reports

Recommended Posts

Hi,

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

image.png.77fd76e426c3a8f62f4c3eb47cb9920c.png

 

This logon was actually 9am.

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

Regards,

 

Will.

Share this post


Link to post
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

Nikolaj

image.thumb.png.2ffe80609efdd7fcae280cc8b556a919.png

 

My Project View:

image.png.04e73ef8f9c6ee8d758862464d77149d.png

 

Share this post


Link to post
Share on other sites

@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:

image.png

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

Share this post


Link to post
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...