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?
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)'))
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
