Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Function to determine timezone CET/CEST

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

1 Reply
Anil_Babu_Samineni

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)'))

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)