topic calculation of date difference in QlikView https://community.qlik.com/t5/QlikView/calculation-of-date-difference/m-p/749891#M1029072 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>Which function I have to use to calculate no. of days of given dates?</P><P></P><P>Example:</P><P></P><P>Date1 - date2 = xx days</P><P></P><P>Pls suggest.</P></BODY></HTML> Thu, 19 Feb 2015 09:15:41 GMT Anonymous 2015-02-19T09:15:41Z calculation of date difference https://community.qlik.com/t5/QlikView/calculation-of-date-difference/m-p/749891#M1029072 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>Which function I have to use to calculate no. of days of given dates?</P><P></P><P>Example:</P><P></P><P>Date1 - date2 = xx days</P><P></P><P>Pls suggest.</P></BODY></HTML> Thu, 19 Feb 2015 09:15:41 GMT https://community.qlik.com/t5/QlikView/calculation-of-date-difference/m-p/749891#M1029072 Anonymous 2015-02-19T09:15:41Z Re: calculation of date difference https://community.qlik.com/t5/QlikView/calculation-of-date-difference/m-p/749892#M1029073 <HTML><HEAD></HEAD><BODY><P>interval(date(DATE_CLOSED)- date(DATE_REPORTED),'d') as [No of Days]</P></BODY></HTML> Thu, 19 Feb 2015 09:19:45 GMT https://community.qlik.com/t5/QlikView/calculation-of-date-difference/m-p/749892#M1029073 Anonymous 2015-02-19T09:19:45Z Re: calculation of date difference https://community.qlik.com/t5/QlikView/calculation-of-date-difference/m-p/749893#M1029074 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Interval(Date1-Date2,'d')</STRONG></SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG><BR /></STRONG></SPAN></P><P>Example</P><P></P><P>=Interval('1/1/2015'-'2/1/2014','d')</P><P></P><P>Answer: 334</P></BODY></HTML> Thu, 19 Feb 2015 09:20:47 GMT https://community.qlik.com/t5/QlikView/calculation-of-date-difference/m-p/749893#M1029074 robert_mika 2015-02-19T09:20:47Z Re: calculation of date difference https://community.qlik.com/t5/QlikView/calculation-of-date-difference/m-p/749894#M1029075 <HTML><HEAD></HEAD><BODY><P>use Interval() function, if you want net working days difference then use networkingdays() function.</P></BODY></HTML> Thu, 19 Feb 2015 09:27:13 GMT https://community.qlik.com/t5/QlikView/calculation-of-date-difference/m-p/749894#M1029075 avinashelite 2015-02-19T09:27:13Z Re: calculation of date difference https://community.qlik.com/t5/QlikView/calculation-of-date-difference/m-p/749895#M1029076 <HTML><HEAD></HEAD><BODY><P>Use Interval() to calculate day difference or convert date into number &amp; simply subtracts 2 dates </P></BODY></HTML> Thu, 19 Feb 2015 09:42:52 GMT https://community.qlik.com/t5/QlikView/calculation-of-date-difference/m-p/749895#M1029076 mukesh24 2015-02-19T09:42:52Z