Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)'))