Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Try this  :

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

 

I hope this helps

Highlighted
Creator
Creator

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

Highlighted
Partner
Partner

Great!

 

Close the thread by selecting correct answer