Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
qvqfqlik
Creator
Creator

time conversion

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

Labels (1)
3 Replies
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Try this  :

=converttolocaltime(converttolocaltime(fieldname,'UTC'),'Pacific Time (USA & Canada)')

 

I hope this helps

qvqfqlik
Creator
Creator
Author

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

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Great!

 

Close the thread by selecting correct answer