Qlik Sense-convert server reloadtime to Local time

[sujeet_shirude]

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

[Anonymous · Accepted solution]

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]

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)