Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna20
Specialist II
Specialist II

PST to GMT or UTC

Hi Folks,

I am having DB data which is logged in PST format and i need to convert into GMT or UTC with Daylight saving. 

Currently i am using Timestamp(ConvertToLocalTime(DateTime,'GMT+7:00'),True()) .

The above logic is not working as expected.

Could anyone advise on this topic??

 

Thanks & Regards

Krishna

1 Solution

Accepted Solutions
Brett_Bleess
Former Employee
Former Employee

Check the Help, you have True for the ignore DST, you want False I believe! 🙂

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Da...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

4 Replies
Somasundaram
Creator III
Creator III

Try this link,

 

https://community.qlik.com/t5/QlikView-App-Development/how-to-convert-a-local-time-to-utc-time-when-...


-Somasundaram

If this resolves your Query please like and accept this as an answer.
krishna20
Specialist II
Specialist II
Author

Thanks for your reply. This logic is working only for without Daylight. With Daylight it's not working.

 

krishna20
Specialist II
Specialist II
Author

Does anyone faced this issue??
Brett_Bleess
Former Employee
Former Employee

Check the Help, you have True for the ignore DST, you want False I believe! 🙂

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Da...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.