Convert local time to GMT

[#1]

Hi guys,

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

Saurabh

[Anonymous]

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]

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