topic Problem with date conversion in QlikView https://community.qlik.com/t5/QlikView/Problem-with-date-conversion/m-p/1100772#M918801 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>I have a list box Yearmonth which i haved attached below.My requirement is to show&nbsp; Date in&nbsp; <STRONG>TextBox</STRONG> in MM/DD/YYYY format when i click a date in listbox.</P><P></P><P></P><P>Regards</P><P>Tripati</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Problem with date conversion https://community.qlik.com/t5/QlikView/Problem-with-date-conversion/m-p/1100772#M918801 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>I have a list box Yearmonth which i haved attached below.My requirement is to show&nbsp; Date in&nbsp; <STRONG>TextBox</STRONG> in MM/DD/YYYY format when i click a date in listbox.</P><P></P><P></P><P>Regards</P><P>Tripati</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Problem-with-date-conversion/m-p/1100772#M918801 2020-11-25T16:16:04Z Re: Problem with date conversion https://community.qlik.com/t5/QlikView/Problem-with-date-conversion/m-p/1100773#M918802 <HTML><HEAD></HEAD><BODY><P>I think you need to fix your date field in the script. You can try something like this</P><P></P><P><STRONG>Date(Num#(YearMonth), 'YYYYMM') as YearMonth</STRONG></P><P></P><P>Read more about how to get dates correctly in QlikView here:</P><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A>‌</P><P><A href="https://community.qlik.com/qlik-blogpost/2954">Why don’t my dates work?</A></P></BODY></HTML> Mon, 09 May 2016 15:25:48 GMT https://community.qlik.com/t5/QlikView/Problem-with-date-conversion/m-p/1100773#M918802 sunny_talwar 2016-05-09T15:25:48Z