topic Qlik Sense-convert server reloadtime to Local time in App Development

Qlik Sense-convert server reloadtime to Local time

sujeet_shirude — Thu, 22 Mar 2018 18:37:28 GMT

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

Re: Qlik Sense-convert server reloadtime to Local time

Anonymous — Thu, 22 Mar 2018 19:04:06 GMT

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 ?

Re: Qlik Sense-convert server reloadtime to Local time

sujeet_shirude — Thu, 22 Mar 2018 19:10:24 GMT

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)