Function to determine timezone CET/CEST

Wed, 25 Nov 2020 16:16:04 GMT

Hello

I have a variable 'refreshdate' which displays time of a certain region.

Example:

=Timestamp(Amsterdam, 'D MMM YYYY hh:mm:ss') & ' (CET)'

In the vraible amsterdam, i am getting the local time of Amsterdam.

The local time is CET is winter and CEST in summer. Since CET is harcoded in my formula. even the time is right, the timezone is alwyas mentioned as CET.

I want the timezone to automatically change according to summer time setting.

What i can replcae the '(CET)' with so that it changes automatically?

Thanks

Aravind

Re: Function to determine timezone CET/CEST

Anil_Babu_Samineni — Wed, 18 Oct 2017 01:01:44 GMT

If you have Date field, Then i would prefer work in basis this condition. From Date field you can create month then

If(Month >= 'Oct' and Month <= 'Feb', Timestamp(Amsterdam, 'D MMM YYYY hh:mm:ss') & ' (CET)',

If(Month >= 'Feb' and Month <= 'Jun', Timestamp(Amsterdam, 'D MMM YYYY hh:mm:ss') & ' (CEST)', Timestamp(Amsterdam, 'D MMM YYYY hh:mm:ss') & ' (Something)'))

topic Re: Function to determine timezone CET/CEST in QlikView

Function to determine timezone CET/CEST

Re: Function to determine timezone CET/CEST