Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

sujeet_shirude
Contributor

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

Tags (1)
2 Replies

Re: Qlik Sense-convert server reloadtime to Local time

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
Contributor

Re: Qlik Sense-convert server reloadtime to Local time

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)

Community Browser