topic how to find day count in QlikView https://community.qlik.com/t5/QlikView/how-to-find-day-count/m-p/415755#M1157012 <HTML><HEAD></HEAD><BODY><P>how to find day count</P></BODY></HTML> Fri, 11 Jan 2013 15:53:46 GMT 2013-01-11T15:53:46Z how to find day count https://community.qlik.com/t5/QlikView/how-to-find-day-count/m-p/415755#M1157012 <HTML><HEAD></HEAD><BODY><P>how to find day count</P></BODY></HTML> Fri, 11 Jan 2013 15:53:46 GMT https://community.qlik.com/t5/QlikView/how-to-find-day-count/m-p/415755#M1157012 2013-01-11T15:53:46Z Re: how to find day count https://community.qlik.com/t5/QlikView/how-to-find-day-count/m-p/415756#M1157013 <HTML><HEAD></HEAD><BODY><P>What do you mean ?</P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><P>NumberOfDaysBetween2Dates=Date1-Date2</P></TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P>Hope that helps you</P><P></P><P>Martin Favier</P></BODY></HTML> Fri, 11 Jan 2013 15:55:17 GMT https://community.qlik.com/t5/QlikView/how-to-find-day-count/m-p/415756#M1157013 martin59 2013-01-11T15:55:17Z Re: how to find day count https://community.qlik.com/t5/QlikView/how-to-find-day-count/m-p/415757#M1157014 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> Use interval() function</P><P></P><P>For Ex:</P><P></P><P>Interval(Today()-(Today()-2),'D') gives 2</P><P></P><P>hope it helps</P></BODY></HTML> Fri, 11 Jan 2013 18:43:37 GMT https://community.qlik.com/t5/QlikView/how-to-find-day-count/m-p/415757#M1157014 MayilVahanan 2013-01-11T18:43:37Z Re: how to find day count https://community.qlik.com/t5/QlikView/how-to-find-day-count/m-p/415758#M1157015 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If I understand you well, you want to know the function to count the day of the year?</P><P></P><P>If that is the case,use this function</P><P></P><P>=DayNumberOfYear(Today(),1)</P><P>1 is the number of the month</P><P></P><P></P><P>Let me know if it works.</P><P></P><P>Regards,</P><P>Gabriel</P></BODY></HTML> Thu, 17 Jan 2013 23:45:18 GMT https://community.qlik.com/t5/QlikView/how-to-find-day-count/m-p/415758#M1157015 Gabriel 2013-01-17T23:45:18Z