topic Convert Day Number of year to date in QlikView https://community.qlik.com/t5/QlikView/Convert-Day-Number-of-year-to-date/m-p/342163#M493800 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>How do I convert day number of the year to a month, day date?&nbsp; It shouldn't give me year and I don't want it too.</P><P></P><P>Regards,</P><P>Brandon</P></BODY></HTML> Tue, 08 May 2012 18:14:03 GMT 2012-05-08T18:14:03Z Convert Day Number of year to date https://community.qlik.com/t5/QlikView/Convert-Day-Number-of-year-to-date/m-p/342163#M493800 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>How do I convert day number of the year to a month, day date?&nbsp; It shouldn't give me year and I don't want it too.</P><P></P><P>Regards,</P><P>Brandon</P></BODY></HTML> Tue, 08 May 2012 18:14:03 GMT https://community.qlik.com/t5/QlikView/Convert-Day-Number-of-year-to-date/m-p/342163#M493800 2012-05-08T18:14:03Z Convert Day Number of year to date https://community.qlik.com/t5/QlikView/Convert-Day-Number-of-year-to-date/m-p/342164#M493803 <HTML><HEAD></HEAD><BODY><P>The QV function daynumberofyear() always uses years based on 366 days (leap years). So we can use e.g. this year to calculate the month and day. If you have a field containing the DayNumberOfYear called DNOY, try</P><P></P><P><EM>LOAD</EM></P><P><EM>DNOY,</EM></P><P><EM>day(makedate(2012)-1+DNOY) as Day,</EM></P><P><EM>month(makedate(2012)-1+DNOY) as Month</EM></P><P><EM>FROM ...;</EM></P></BODY></HTML> Tue, 08 May 2012 18:26:24 GMT https://community.qlik.com/t5/QlikView/Convert-Day-Number-of-year-to-date/m-p/342164#M493803 swuehl 2012-05-08T18:26:24Z