topic Re: Timezone Convert in QlikView

Timezone Convert

nihhalmca — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Timezone Convert

rwunderlich — Wed, 29 Nov 2017 18:07:33 GMT

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

Re: Timezone Convert

johnca — Wed, 29 Nov 2017 21:19:26 GMT

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

Re: Timezone Convert

nihhalmca — Fri, 08 Dec 2017 10:37:50 GMT

Thanks Rob.

Re: Timezone Convert

johnca — Fri, 08 Dec 2017 20:40:40 GMT

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

Re: Timezone Convert

chetanpatel — Wed, 16 Sep 2020 22:01:10 GMT

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