topic Datediff in working days in QlikView https://community.qlik.com/t5/QlikView/Datediff-in-working-days/m-p/603462#M222975 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to work out the days between the invoice date, and date paid, which I've done as and expression:</P><P></P><P>date(date_paid)-(date(invoice_date))</P><P></P><P>But........ is there any way I can change this so it gives the results in working days, and not just days?</P><P></P><P>Thanks</P><P></P><P>Di</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P></BODY></HTML> Wed, 05 Mar 2014 10:52:03 GMT dinicholls 2014-03-05T10:52:03Z Datediff in working days https://community.qlik.com/t5/QlikView/Datediff-in-working-days/m-p/603462#M222975 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to work out the days between the invoice date, and date paid, which I've done as and expression:</P><P></P><P>date(date_paid)-(date(invoice_date))</P><P></P><P>But........ is there any way I can change this so it gives the results in working days, and not just days?</P><P></P><P>Thanks</P><P></P><P>Di</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P></BODY></HTML> Wed, 05 Mar 2014 10:52:03 GMT https://community.qlik.com/t5/QlikView/Datediff-in-working-days/m-p/603462#M222975 dinicholls 2014-03-05T10:52:03Z Re: Datediff in working days https://community.qlik.com/t5/QlikView/Datediff-in-working-days/m-p/603463#M222976 <HTML><HEAD></HEAD><BODY><P>Interval([<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">date_paid</SPAN>]-[i<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">nvoice_date</SPAN>],'D')</P><P>Or </P><P>NetWorkDays([i<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">nvoice_date</SPAN>],[<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">date_paid</SPAN>])</P></BODY></HTML> Wed, 05 Mar 2014 10:55:50 GMT https://community.qlik.com/t5/QlikView/Datediff-in-working-days/m-p/603463#M222976 MK_QSL 2014-03-05T10:55:50Z Re: Datediff in working days https://community.qlik.com/t5/QlikView/Datediff-in-working-days/m-p/603464#M222977 <HTML><HEAD></HEAD><BODY><P>Manish,</P><P></P><P>Thank you!</P><P></P><P>Used NetWorkDays, worked a treat!</P><P></P><P>Di</P></BODY></HTML> Wed, 05 Mar 2014 12:40:25 GMT https://community.qlik.com/t5/QlikView/Datediff-in-working-days/m-p/603464#M222977 dinicholls 2014-03-05T12:40:25Z