topic DayNumberOfYear function in QlikView https://community.qlik.com/t5/QlikView/DayNumberOfYear-function/m-p/2701#M387 <HTML><HEAD></HEAD><BODY><P>Good day all</P><P></P><P>Can someone please explain why Qlikview uses 366 days for the DayNumberOfYear function and if there's any way of getting around this. E.g. if I'm looking for number of days when February ends on the 28th I still get 366, shouldn't I be getting 365?</P><P></P><P>Thanks and looking forwards to the responses.</P><P>Matlotlo</P></BODY></HTML> Thu, 18 Jan 2018 08:21:36 GMT nkosinde13 2018-01-18T08:21:36Z DayNumberOfYear function https://community.qlik.com/t5/QlikView/DayNumberOfYear-function/m-p/2701#M387 <HTML><HEAD></HEAD><BODY><P>Good day all</P><P></P><P>Can someone please explain why Qlikview uses 366 days for the DayNumberOfYear function and if there's any way of getting around this. E.g. if I'm looking for number of days when February ends on the 28th I still get 366, shouldn't I be getting 365?</P><P></P><P>Thanks and looking forwards to the responses.</P><P>Matlotlo</P></BODY></HTML> Thu, 18 Jan 2018 08:21:36 GMT https://community.qlik.com/t5/QlikView/DayNumberOfYear-function/m-p/2701#M387 nkosinde13 2018-01-18T08:21:36Z Re: DayNumberOfYear function https://community.qlik.com/t5/QlikView/DayNumberOfYear-function/m-p/2702#M388 <HTML><HEAD></HEAD><BODY><P>Totally agree.&nbsp; I just ran into this design bug with our master calendar. </P><P></P><P>Now I have to use calendardate - yearstart(calendardate) + 1</P><P></P><P>As the Sicilian would say - INCONCEIVEABLE!!!</P></BODY></HTML> Wed, 29 Aug 2018 12:29:30 GMT https://community.qlik.com/t5/QlikView/DayNumberOfYear-function/m-p/2702#M388 markp201 2018-08-29T12:29:30Z