Solved: PST to GMT or UTC - Qlik Community

krishna20 · ‎2019-03-26

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

Brett_Bleess · ‎2019-05-14

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

Somasundaram · ‎2019-03-26

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 · ‎2019-03-26

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

krishna20 · ‎2019-03-26

Does anyone faced this issue??

Brett_Bleess · ‎2019-05-14

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.