topic Turn yeardaynumber into date in QlikView

topic Turn yeardaynumber into date in QlikView https://community.qlik.com/t5/QlikView/Turn-yeardaynumber-into-date/m-p/390961#M1163729 <HTML><HEAD></HEAD><BODY><P>How can I turn a yeardaynumber into a date eg </P><P></P><P>12001 --> 01-01-2012 or </P><P>12282 --> 08-10-2012</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 08 Oct 2012 13:09:54 GMT 2012-10-08T13:09:54Z Turn yeardaynumber into date https://community.qlik.com/t5/QlikView/Turn-yeardaynumber-into-date/m-p/390961#M1163729 <HTML><HEAD></HEAD><BODY><P>How can I turn a yeardaynumber into a date eg </P><P></P><P>12001 --> 01-01-2012 or </P><P>12282 --> 08-10-2012</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 08 Oct 2012 13:09:54 GMT https://community.qlik.com/t5/QlikView/Turn-yeardaynumber-into-date/m-p/390961#M1163729 2012-10-08T13:09:54Z Re: Turn yeardaynumber into date https://community.qlik.com/t5/QlikView/Turn-yeardaynumber-into-date/m-p/390962#M1163730 <HTML><HEAD></HEAD><BODY><P>makedate(left(YearDayNumber,2)+2000,1,1) + Right(YearDayNumber,3) -1  as MyDate</P></BODY></HTML> Mon, 08 Oct 2012 13:48:28 GMT https://community.qlik.com/t5/QlikView/Turn-yeardaynumber-into-date/m-p/390962#M1163730 Gysbert_Wassenaar 2012-10-08T13:48:28Z