Timezone Convert

[nihhalmca]

Hi All,

I want to convert reload() time into CET zone and tried below logic however, it is not working.

=ConverttoLocaltime(reloadtime(),'UTC+01:00')

Reloadtime() is CST zone (usa).

Thanks,

Nihhal.

[rwunderlich · Accepted solution]

As the difference between CET and CST is 7 hours, I think you just want to add 7 hours.

TimeStamp(ReloadTime() + MakeTime(7))

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[johnca]

Nihhal,

What is the problem you are seeing exactly?

I understand your need to use ConvertToLocalTime since we in the US like to use daylight savings during summer months.

This thread Convert to GMT with DST adjustment will help. Finding the right major US city/time zone to use in the DST adjustment is the fun part. I've tested this with 'Baja California' and it worked for me:

ConvertToLocalTime('2017-08-29 10:30:00','Baja California',0) will be 1 hour different than ConvertToLocalTime('2017-08-29 10:30:00','Baja California',1). Note the DST flag either 0 or 1.

Also, note that the conversion will only appear to work during DST months. If I did the same above to today's date it would not change.

--john

[nihhalmca]

Thanks Rob.

[johnca]

Hey Rob, does CET use daylight savings? I mean, when the US "Springs Forward" or "Falls Back" does CET follow suit? If so, I agree with you. If not, then this method will be 1 hour off half the year.

--john

[chetanpatel]

How  about daylight saving time when i have  to  convert CST  to Hawaii time.