topic numdat in QlikView https://community.qlik.com/t5/QlikView/numdat/m-p/448830#M701778 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am looking for the right command to make a date numeric for using in the calender table</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">PINKD day is 6 long, format YYMMDD and this command is working.</SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style=": ; color: #0000ff; font-size: 8pt;"></SPAN></SPAN></P><P>num</P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">makedate</SPAN><SPAN style="font-size: 8pt;">('20'&amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">left</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">PINKD</SPAN><SPAN style="font-size: 8pt;">,2),</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">mid</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">PINKD</SPAN><SPAN style="font-size: 8pt;">,3,2),</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">right</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">PINKD</SPAN><SPAN style="font-size: 8pt;">,2))) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">PINKD</SPAN><P></P><P></P><P><SPAN style="color: #800000;">Now i want the same for a field (BEDATA) , 8 long with format CCYYMMDD</SPAN></P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">makedate</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">BEDATA</SPAN><SPAN style="font-size: 8pt;">)) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">BEDATA</SPAN></P><P></P><P><SPAN style="color: #800000; font-size: 8pt;">is not working</SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">Anyone an idea?</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Regards,</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Ron Laurens</SPAN></P><P><SPAN style="font-size: 8pt;"> </SPAN></P></BODY></HTML> Thu, 27 Sep 2012 13:26:28 GMT 2012-09-27T13:26:28Z numdat https://community.qlik.com/t5/QlikView/numdat/m-p/448830#M701778 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am looking for the right command to make a date numeric for using in the calender table</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">PINKD day is 6 long, format YYMMDD and this command is working.</SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style=": ; color: #0000ff; font-size: 8pt;"></SPAN></SPAN></P><P>num</P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">makedate</SPAN><SPAN style="font-size: 8pt;">('20'&amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">left</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">PINKD</SPAN><SPAN style="font-size: 8pt;">,2),</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">mid</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">PINKD</SPAN><SPAN style="font-size: 8pt;">,3,2),</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">right</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">PINKD</SPAN><SPAN style="font-size: 8pt;">,2))) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">PINKD</SPAN><P></P><P></P><P><SPAN style="color: #800000;">Now i want the same for a field (BEDATA) , 8 long with format CCYYMMDD</SPAN></P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">makedate</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">BEDATA</SPAN><SPAN style="font-size: 8pt;">)) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">BEDATA</SPAN></P><P></P><P><SPAN style="color: #800000; font-size: 8pt;">is not working</SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">Anyone an idea?</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Regards,</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Ron Laurens</SPAN></P><P><SPAN style="font-size: 8pt;"> </SPAN></P></BODY></HTML> Thu, 27 Sep 2012 13:26:28 GMT https://community.qlik.com/t5/QlikView/numdat/m-p/448830#M701778 2012-09-27T13:26:28Z Re: numdat https://community.qlik.com/t5/QlikView/numdat/m-p/448831#M701779 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">num</SPAN><SPAN style="font-size: 8pt;">(Date#(</SPAN><SPAN style="color: #800000; font-size: 8pt;">BEDATA,'YYYYMMDD'</SPAN><SPAN style="font-size: 8pt;">)) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">BEDATA</SPAN></P></BODY></HTML> Thu, 27 Sep 2012 13:28:37 GMT https://community.qlik.com/t5/QlikView/numdat/m-p/448831#M701779 swuehl 2012-09-27T13:28:37Z