topic Re: DayNumberOfYear Function... in QlikView https://community.qlik.com/t5/QlikView/DayNumberOfYear-Function/m-p/1019279#M945096 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P><A href="https://community.qlik.com/message/217372">Convert Day Number of year to date</A></P><P></P><P>abve link helps u what u want exact..</P><P></P><P>thanks 'S</P><P>Suresh</P></BODY></HTML> Mon, 04 Jan 2016 13:01:57 GMT Chanty4u 2016-01-04T13:01:57Z DayNumberOfYear Function... https://community.qlik.com/t5/QlikView/DayNumberOfYear-Function/m-p/1019278#M945095 <HTML><HEAD></HEAD><BODY><P>Dear QV Experts,</P><P></P><P>DayNumberOfYear Function returns 366 days though my year is 2015. <BR />Can you please suggest to return as 365 days. Because it impacts the Annualized calculation if not leap year.</P><P></P><P>Appreciate your prompt response.</P><P></P><P>Thanks,<BR />Sasi</P></BODY></HTML> Mon, 04 Jan 2016 12:59:33 GMT https://community.qlik.com/t5/QlikView/DayNumberOfYear-Function/m-p/1019278#M945095 2016-01-04T12:59:33Z Re: DayNumberOfYear Function... https://community.qlik.com/t5/QlikView/DayNumberOfYear-Function/m-p/1019279#M945096 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P><A href="https://community.qlik.com/message/217372">Convert Day Number of year to date</A></P><P></P><P>abve link helps u what u want exact..</P><P></P><P>thanks 'S</P><P>Suresh</P></BODY></HTML> Mon, 04 Jan 2016 13:01:57 GMT https://community.qlik.com/t5/QlikView/DayNumberOfYear-Function/m-p/1019279#M945096 Chanty4u 2016-01-04T13:01:57Z Re: DayNumberOfYear Function... https://community.qlik.com/t5/QlikView/DayNumberOfYear-Function/m-p/1019280#M945097 <HTML><HEAD></HEAD><BODY><P>To quote swuehl's respsonse in the above thread:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&gt;&gt;The QV function daynumberofyear() always uses years based on 366 days (leap years).</SPAN></P></BODY></HTML> Mon, 04 Jan 2016 13:16:00 GMT https://community.qlik.com/t5/QlikView/DayNumberOfYear-Function/m-p/1019280#M945097 jonathandienst 2016-01-04T13:16:00Z Re: DayNumberOfYear Function... https://community.qlik.com/t5/QlikView/DayNumberOfYear-Function/m-p/1019281#M945098 <HTML><HEAD></HEAD><BODY><P>Hi Sasi ,</P><P></P><P><STRONG>In Back End :</STRONG></P><P><STRONG><BR /></STRONG></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14519136017295304 jive_text_macro" jivemacro_uid="_14519136017295304" modifiedtitle="true"> <P>DayNumberOfYear(Date) as DayNumber,</P> </PRE><P></P><P></P><P><A href="http://www.qlikviewaddict.com/2013/03/dates-in-qlikview-part-3.html" style="font-size: 10pt; line-height: 1.5em;" title="http://www.qlikviewaddict.com/2013/03/dates-in-qlikview-part-3.html">http://www.qlikviewaddict.com/2013/03/dates-in-qlikview-part-3.html</A></P><P></P><P>HTH,</P><P>Hirish</P></BODY></HTML> Mon, 04 Jan 2016 13:22:58 GMT https://community.qlik.com/t5/QlikView/DayNumberOfYear-Function/m-p/1019281#M945098 HirisH_V7 2016-01-04T13:22:58Z Re: DayNumberOfYear Function... https://community.qlik.com/t5/QlikView/DayNumberOfYear-Function/m-p/1019282#M945099 <HTML><HEAD></HEAD><BODY><P>Hi Sasi, as said above DayNumberOfYear() always returns 366 days. To calculate real days you can use:</P><P>=Date(CYEndDate)-YearStart(Date(CYEndDate))+1</P></BODY></HTML> Mon, 04 Jan 2016 14:04:03 GMT https://community.qlik.com/t5/QlikView/DayNumberOfYear-Function/m-p/1019282#M945099 rubenmarin 2016-01-04T14:04:03Z Re: DayNumberOfYear Function... https://community.qlik.com/t5/QlikView/DayNumberOfYear-Function/m-p/1019283#M945100 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Ruben &amp; All.</P></BODY></HTML> Mon, 04 Jan 2016 15:13:43 GMT https://community.qlik.com/t5/QlikView/DayNumberOfYear-Function/m-p/1019283#M945100 2016-01-04T15:13:43Z