https://community.qlik.com/t5/App-Development/Convert-CST-to-Eastern-Time-Zone/m-p/1982036#M81039 <P>I have the following code:<BR /><BR /></P> <PRE class="c-mrkdwn__pre" data-stringify-type="pre">if ('$(pTimeZone)' = 'CST',Timestamp(ConvertToLocalTime(LatestDate,'Eastern Time (US &amp; Canada)'),'MM-DD-YYYY hh:mm tt')</PRE> <P>my LatestDate value is&nbsp; 2022-09-16 08:56 in CST<BR /><BR />But my conversion above gives me the output 09-06-2022 04:56 am<BR /><BR />which is wrong.<BR /><BR />Can anyone please suggest why am I getting the wrong answer?</P> Fri, 16 Sep 2022 14:13:25 GMT jchacko_rxsense 2022-09-16T14:13:25Z https://community.qlik.com/t5/App-Development/Convert-CST-to-Eastern-Time-Zone/m-p/1982036#M81039 <P>I have the following code:<BR /><BR /></P> <PRE class="c-mrkdwn__pre" data-stringify-type="pre">if ('$(pTimeZone)' = 'CST',Timestamp(ConvertToLocalTime(LatestDate,'Eastern Time (US &amp; Canada)'),'MM-DD-YYYY hh:mm tt')</PRE> <P>my LatestDate value is&nbsp; 2022-09-16 08:56 in CST<BR /><BR />But my conversion above gives me the output 09-06-2022 04:56 am<BR /><BR />which is wrong.<BR /><BR />Can anyone please suggest why am I getting the wrong answer?</P> Fri, 16 Sep 2022 14:13:25 GMT https://community.qlik.com/t5/App-Development/Convert-CST-to-Eastern-Time-Zone/m-p/1982036#M81039 jchacko_rxsense 2022-09-16T14:13:25Z