topic Converting Timestamp from PST to EDT in QlikView

Converting Timestamp from PST to EDT

ryan32887 — Tue, 19 May 2020 17:55:35 GMT

I've tried a plethora of different scenarios here and my problem revolves around DST, currently my formula works for non-DST but DST is one hour off (long).

Timestamp(ConvertToLocalTime(ConvertToLocalTime(Date,'GMT+08:00'),'GMT-04:00'),'M/D/YY hh:mm TT')

I have tried ignoring DST on both sides but whenever I try that, my output is the same, here is my syntax on that piece:

ConvertToLocalTime(Date,'GMT+08:00',True())

Re: Converting Timestamp from PST to EDT

Or — Tue, 19 May 2020 18:03:04 GMT

Lifted directly from the Qlik Help site:

When processing a timestamp with a date or time function, QlikView ignores any daylight savings time parameters unless the date or time function includes a geographical position.

For example, ConvertToLocalTime( filetime('Time.qvd'), 'Paris') would use daylight savings time parameters while ConvertToLocalTime(filetime('Time.qvd'), 'GMT-01:00') would not use daylight savings time parameters.

Re: Converting Timestamp from PST to EDT

ryan32887 — Tue, 19 May 2020 18:10:01 GMT

I've tried the below, this gives me non-DST is one hour short and DST in one hour long.

Converting PST to GMT, then converting GMT to EDT.

Timestamp(ConvertToLocalTime(ConvertToLocalTime([Reply Date],'GMT+08:00'),'Eastern Time (US & Canada)'),'M/D/YY hh:mm TT')

Re: Converting Timestamp from PST to EDT

Or — Tue, 19 May 2020 18:28:01 GMT

I used your formula and it appears to work correctly:

=ConvertToLocalTime(ConvertToLocalTime('2020-06-06 00:00:00','GMT+08:00'),'New York') returns 4am which is correct

=ConvertToLocalTime(ConvertToLocalTime('2020-01-01 00:00:00','GMT+08:00'),'New York') returns 3am which is correct

I'm not sure why you're comparing PST to DST in the first place, but I'm sure you have your reasons - that said, you seem to have the right formula in place so I'm not sure what the issue is.