Convert to GMT+4

[#1]

Hi All,

I am currently using the below to convert my time:

Time(Frac(CallUniversalTime), 'hh:mm:ss') as Time

However, I need to convert this time to GMT+4.

Any Idea how i can incorporate it in my load script.

Many Thanks,

Hasvine

[maxgro · Accepted solution]

try with ConvertToLocalTime  (this is from Qlik help)

ConvertToLocalTime(timestamp [, place [, ignore_dst=false]])

Converts a UTC or GMT timestamp to local time as a dual value. The place can be any of a number of cities, places and time zones around the world.

ConvertToLocalTime(UTC(), ’GMT-05:00’) returns the time for the North American east coast

[sunny_talwar]

Using maxgro‌ provided function, try this:

=Time(Frac(ConvertToLocalTime(CallUniversalTime, 'GMT+04:00')), 'hh:mm:ss')