topic ConvertToLocalTime issue in QlikView https://community.qlik.com/t5/QlikView/ConvertToLocalTime-issue/m-p/209792#M64652 <HTML><HEAD></HEAD><BODY><P>I have this expression:</P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=ConvertToLocalTime('1/1/2010 2:00:00 AM', 'GMT-08:00') &amp; '\n' &amp;<BR />ConvertToLocalTime('1/1/2010 2:00:00 AM', 'Pacific Time (US &amp; Canada)')</PRE><BR /><BR /> <P>The result is:</P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">GMT-08:00?\n12/31/2009 6:00:00 PM</PRE><BR /><BR /> <P>What's wrong with using 'GMT-08:00' as a place parameter?</P><P>QV 9.00.7440.8 SR3</P><P>Windows Seven x86 Ultimate</P></BODY></HTML> Sat, 10 Apr 2010 05:34:20 GMT 2010-04-10T05:34:20Z ConvertToLocalTime issue https://community.qlik.com/t5/QlikView/ConvertToLocalTime-issue/m-p/209792#M64652 <HTML><HEAD></HEAD><BODY><P>I have this expression:</P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=ConvertToLocalTime('1/1/2010 2:00:00 AM', 'GMT-08:00') &amp; '\n' &amp;<BR />ConvertToLocalTime('1/1/2010 2:00:00 AM', 'Pacific Time (US &amp; Canada)')</PRE><BR /><BR /> <P>The result is:</P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">GMT-08:00?\n12/31/2009 6:00:00 PM</PRE><BR /><BR /> <P>What's wrong with using 'GMT-08:00' as a place parameter?</P><P>QV 9.00.7440.8 SR3</P><P>Windows Seven x86 Ultimate</P></BODY></HTML> Sat, 10 Apr 2010 05:34:20 GMT https://community.qlik.com/t5/QlikView/ConvertToLocalTime-issue/m-p/209792#M64652 2010-04-10T05:34:20Z ConvertToLocalTime issue https://community.qlik.com/t5/QlikView/ConvertToLocalTime-issue/m-p/209793#M64653 <HTML><HEAD></HEAD><BODY><P>Nick,</P><P>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.</P></BODY></HTML> Sat, 10 Apr 2010 16:16:04 GMT https://community.qlik.com/t5/QlikView/ConvertToLocalTime-issue/m-p/209793#M64653 Oleg_Troyansky 2010-04-10T16:16:04Z ConvertToLocalTime issue https://community.qlik.com/t5/QlikView/ConvertToLocalTime-issue/m-p/209794#M64654 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Sat, 10 Apr 2010 18:56:04 GMT https://community.qlik.com/t5/QlikView/ConvertToLocalTime-issue/m-p/209794#M64654 2010-04-10T18:56:04Z ConvertToLocalTime issue https://community.qlik.com/t5/QlikView/ConvertToLocalTime-issue/m-p/209795#M64655 <HTML><HEAD></HEAD><BODY><P>Sounds like it... Please report it to QlikTech.</P></BODY></HTML> Sun, 11 Apr 2010 02:13:25 GMT https://community.qlik.com/t5/QlikView/ConvertToLocalTime-issue/m-p/209795#M64655 Oleg_Troyansky 2010-04-11T02:13:25Z