Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sujeet_shirude
Creator II
Creator II

Qlik Sense-convert server reloadtime to Local time

Hi all,

We are using the script below to get the the local ReloadTime(EDT) :

  • ConvertToLocalTime(UTC(ReloadTime()),'Eastern Time (US & Canada)')

UTC(ReloadTime() returns current UTC time but does not conversion of the reloadtime to UTC.

Any insights on how this can done?

Thank you!

Regards,

Sujeet Shirude

1 Solution

Accepted Solutions
Anonymous
Not applicable

The function UTC() does not accept any parameters and simply returns the current UTC timestamp.  It must just be ignoring the parameter, although it would be better if it failed.


ReloadTime() returns the server time which on all our servers is UTC so for us the below would work :


     ConvertToLocalTime(reloadtime(),'Eastern Time (US & Canada)')


What timezone do your servers run on ?

View solution in original post

2 Replies
Anonymous
Not applicable

The function UTC() does not accept any parameters and simply returns the current UTC timestamp.  It must just be ignoring the parameter, although it would be better if it failed.


ReloadTime() returns the server time which on all our servers is UTC so for us the below would work :


     ConvertToLocalTime(reloadtime(),'Eastern Time (US & Canada)')


What timezone do your servers run on ?

sujeet_shirude
Creator II
Creator II
Author

Thanks Bill !

I see, okay. I agree, it would be helpful if it gives a syntax error/Failed message.

Its in Mountain Standard time(MST)