https://community.qlik.com/t5/QlikView/num-DATE/m-p/1554595#M440620 <P>Hi friends</P><P>In QV data load syntax I have following line</P><P>Num(YEAR(T_DATE))&amp; num(MONTH(T_DATE))AS TD_YM, and the result is shown below</P><P>T_DATE&nbsp; &nbsp; &nbsp; TD_YM&nbsp; &nbsp; &nbsp; &nbsp;expeceted TD_YM<BR />31/07/18&nbsp; &nbsp; &nbsp;20187&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<FONT color="#FF0000"> 201807</FONT><BR />01/10/18&nbsp; &nbsp; &nbsp;201810&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;201810</P><P>In the actual output&nbsp; &nbsp;T_date 31/07/18 is shown with 5 dights (20187) whereas I want it to be in 6 digits (<FONT color="#FF0000">201807</FONT>&nbsp;). Kindly help me to modify my script to get expected output.</P><P>&nbsp;</P> Sun, 10 Mar 2019 09:50:18 GMT upaliwije 2019-03-10T09:50:18Z https://community.qlik.com/t5/QlikView/num-DATE/m-p/1554595#M440620 <P>Hi friends</P><P>In QV data load syntax I have following line</P><P>Num(YEAR(T_DATE))&amp; num(MONTH(T_DATE))AS TD_YM, and the result is shown below</P><P>T_DATE&nbsp; &nbsp; &nbsp; TD_YM&nbsp; &nbsp; &nbsp; &nbsp;expeceted TD_YM<BR />31/07/18&nbsp; &nbsp; &nbsp;20187&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<FONT color="#FF0000"> 201807</FONT><BR />01/10/18&nbsp; &nbsp; &nbsp;201810&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;201810</P><P>In the actual output&nbsp; &nbsp;T_date 31/07/18 is shown with 5 dights (20187) whereas I want it to be in 6 digits (<FONT color="#FF0000">201807</FONT>&nbsp;). Kindly help me to modify my script to get expected output.</P><P>&nbsp;</P> Sun, 10 Mar 2019 09:50:18 GMT https://community.qlik.com/t5/QlikView/num-DATE/m-p/1554595#M440620 upaliwije 2019-03-10T09:50:18Z https://community.qlik.com/t5/QlikView/num-DATE/m-p/1555060#M440621 <P>My bad here, when I moved the post, I did not get everything, here is the link to the replies on this one:</P> <P><A href="https://community.qlik.com/t5/QlikView-App-Development/Re-num-DATE/m-p/1554616#M440616" target="_blank">https://community.qlik.com/t5/QlikView-App-Development/Re-num-DATE/m-p/1554616#M440616</A></P> <P>Apologies,<BR />Brett</P> Mon, 11 Mar 2019 21:04:07 GMT https://community.qlik.com/t5/QlikView/num-DATE/m-p/1555060#M440621 Brett_Bleess 2019-03-11T21:04:07Z