Function to determine timezone CET/CEST

[#1]

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

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