Report Time Zone - SQL Schema Designer Reports

[Will J Douglas]

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

 

This logon was actually 9am.

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

Regards,

 

Will.

[Nikolaj]

• Senior Member
•  
• Supportworks Users
•  37
• 191 posts

• Report post
•  
•  

Posted August 2

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

 

My Project View:

 

[Will J Douglas]

Any suggestions to resolve this?

[Victor]

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

[Will J Douglas]

@Victor

Thanks for the feedback.  I've corrected the timezone settings and confirmed all working now.

 

Thanks,

 

Will.