topic Date Conversion Question? in QlikView https://community.qlik.com/t5/QlikView/Date-Conversion-Question/m-p/276400#M103110 <HTML><HEAD></HEAD><BODY><P>Hi Brandon,</P><P></P><P>You may get rid of that leading "1" in the Date#() and set the Date() to display 'DD-MM-YYYY' instead:</P><P></P><P>Date(Date#(Right(mrsdtc, 6), 'YYMMDD'), 'DD-MM-YYYY') AS "MO Date"</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Fri, 13 Jan 2012 21:28:36 GMT Miguel_Angel_Baeyens 2012-01-13T21:28:36Z Date Conversion Question? https://community.qlik.com/t5/QlikView/Date-Conversion-Question/m-p/276399#M103109 <HTML><HEAD></HEAD><BODY><DIV>I have a julian like numeric date i need converted.&nbsp; In this date, today (January 13, 2012) is 1120113.&nbsp; I've tried the code below from looking at other sources, but it doesn't work. </DIV><DIV><SPAN style="color: #008000; font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="color: #008000; font-size: 8pt;"><SPAN style="color: #008000; font-size: 8pt;"><DIV><SPAN style="font-size: 12pt;">date(date#(mrsdtc, '1YYMMDD'), 'DD-MM-20YY') as "MO Date",</SPAN><SPAN style="color: #008000; font-size: 12pt;"> </SPAN></DIV><DIV><SPAN style="color: #008000; font-size: 12pt;"> </SPAN></DIV><DIV> </DIV><DIV> </DIV></SPAN><DIV> </DIV></SPAN></DIV><DIV>Any thoughts?</DIV></BODY></HTML> Fri, 13 Jan 2012 21:00:42 GMT https://community.qlik.com/t5/QlikView/Date-Conversion-Question/m-p/276399#M103109 2012-01-13T21:00:42Z Date Conversion Question? https://community.qlik.com/t5/QlikView/Date-Conversion-Question/m-p/276400#M103110 <HTML><HEAD></HEAD><BODY><P>Hi Brandon,</P><P></P><P>You may get rid of that leading "1" in the Date#() and set the Date() to display 'DD-MM-YYYY' instead:</P><P></P><P>Date(Date#(Right(mrsdtc, 6), 'YYMMDD'), 'DD-MM-YYYY') AS "MO Date"</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Fri, 13 Jan 2012 21:28:36 GMT https://community.qlik.com/t5/QlikView/Date-Conversion-Question/m-p/276400#M103110 Miguel_Angel_Baeyens 2012-01-13T21:28:36Z