Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Iam trying to convert a timestamp to another timestamp.
Reloadtime() result I have in US Central timezone as the server is in central time.
Iam trying to convert this to Pacific time.
Please help with this.
Below is what Iam trying to do. But this not applying the Daylight saving time .
date(date#(if(ConvertToLocalTime(ReloadTime(), 'Central Time (US & Canada)') -
ConvertToLocalTime(ReloadTime(), 'Central Time (US & Canada)', true()) > 0,
ConvertToLocalTime(ReloadTime(), 'GMT-03:00'), ConvertToLocalTime(ReloadTime(), 'GMT-02:00')),
'MM/DD/YYYY hh:mm:ss TT'),'DD-MMM-YYYY hh:mm:ss TT')
Try this :
=converttolocaltime(converttolocaltime(fieldname,'UTC'),'Pacific Time (USA & Canada)')
I hope this helps
this worked now
date(date#(if(ConvertToLocalTime(ReloadTime(), 'Central Time (US & Canada)',true()) -
ConvertToLocalTime(ReloadTime(), 'Central Time (US & Canada)') > 0,
ConvertToLocalTime(ReloadTime(), 'GMT-03:00'), ConvertToLocalTime(ReloadTime(), 'GMT-02:00')),
'MM/DD/YYYY hh:mm:ss TT'),'DD-MMM-YYYY hh:mm:ss TT')
Great!
Close the thread by selecting correct answer