topic Re: Convert local time to GMT in QlikView

Convert local time to GMT

Tue, 10 Dec 2013 15:14:44 GMT

Hi guys,

Is there any way to convert the local time to GMT in Qlikview scripts?

Saurabh

Anonymous — Tue, 10 Dec 2013 15:16:52 GMT

There is function GMT()

Edit: In the script, you can create a variable at the beginning of the script:

LET GMTShift = now() - GMT();

And add this variable to all your local timestamps fields.

Anonymous — Tue, 10 Dec 2013 18:05:09 GMT

Ramya

All our servers are permanently set to GMT [aka UTC].

Then I make use of the ConvertToLocalTime() function should the need arise. It is the opposite way round to your requirement but may be useful.

Best Regards, Bill