Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ConvertToLocalTime issue

I have this expression:

=ConvertToLocalTime('1/1/2010 2:00:00 AM', 'GMT-08:00') & '\n' &
ConvertToLocalTime('1/1/2010 2:00:00 AM', 'Pacific Time (US & Canada)')


The result is:

GMT-08:00?\n12/31/2009 6:00:00 PM


What's wrong with using 'GMT-08:00' as a place parameter?

QV 9.00.7440.8 SR3

Windows Seven x86 Ultimate

Labels (1)
3 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Nick,

I copied and pasted your expression into a text box in my QlikView, and I got the expected result (two identical lines). I'm using QlikView 9.00 7427.8 SR3 , 32-bit, on Windows XP.

Ask me about Qlik Sense Expert Class!
Not applicable
Author

I did it in on my work PC. It works there as well. It has the same QV version on Win Server 2008 EE. I think this is a bug for Windows Seven.

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Sounds like it... Please report it to QlikTech.

Ask me about Qlik Sense Expert Class!