topic Re: How to get the processed days from 2 dates? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576258#M683536 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>[PO Creation] - [PR Approved]</P></BODY></HTML> Fri, 14 Mar 2014 11:15:24 GMT rustyfishbones 2014-03-14T11:15:24Z How to get the processed days from 2 dates? https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576255#M683533 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How can I get the duration of processing from two dates?</P><P></P><P>From PR Approved date to PO creation date including the weekend?</P><P></P><P>Thanks a lot!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Regards,</P><P></P><P>Ahyel</P></BODY></HTML> Fri, 14 Mar 2014 10:52:19 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576255#M683533 2014-03-14T10:52:19Z Re: How to get the processed days from 2 dates? https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576256#M683534 <HTML><HEAD></HEAD><BODY><P>Use Below Function...<BR />=NetWorkDays(StartDate, EndDate)</P><P>Or</P><P></P><P>=Interval(EndDate-StartDate,'D')</P></BODY></HTML> Fri, 14 Mar 2014 11:04:07 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576256#M683534 MK_QSL 2014-03-14T11:04:07Z Re: How to get the processed days from 2 dates? https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576257#M683535 <HTML><HEAD></HEAD><BODY><P>Alternatively</P><P></P><P>num(PR Approved Date) - num(PO creation date)</P></BODY></HTML> Fri, 14 Mar 2014 11:08:14 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576257#M683535 marcus_malinow 2014-03-14T11:08:14Z Re: How to get the processed days from 2 dates? https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576258#M683536 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>[PO Creation] - [PR Approved]</P></BODY></HTML> Fri, 14 Mar 2014 11:15:24 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576258#M683536 rustyfishbones 2014-03-14T11:15:24Z Re: How to get the processed days from 2 dates? https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576259#M683537 <HTML><HEAD></HEAD><BODY><P>Or like Manish said</P><P></P><P><IMG alt="2014-03-14_1120.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/55053_2014-03-14_1120.png" /></P></BODY></HTML> Fri, 14 Mar 2014 11:21:28 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576259#M683537 rustyfishbones 2014-03-14T11:21:28Z Re: How to get the processed days from 2 dates? https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576260#M683538 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Networkday excludes weekends right? How to include weekends in the count?</P><P></P><P>Thank you</P></BODY></HTML> Fri, 14 Mar 2014 11:28:02 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576260#M683538 2014-03-14T11:28:02Z Re: How to get the processed days from 2 dates? https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576261#M683539 <HTML><HEAD></HEAD><BODY><P>NetWorkdays() : Returns the number of working days (Monday-Friday).</P><P></P><P>Better to use Interval(Enddate-StartDate,'D')</P></BODY></HTML> Fri, 14 Mar 2014 11:30:16 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576261#M683539 manojkulkarni 2014-03-14T11:30:16Z Re: How to get the processed days from  2 dates? https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576262#M683540 <HTML><HEAD></HEAD><BODY><P>use my second option.</P></BODY></HTML> Fri, 14 Mar 2014 11:38:00 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576262#M683540 MK_QSL 2014-03-14T11:38:00Z Re: How to get the processed days from 2 dates? https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576263#M683541 <HTML><HEAD></HEAD><BODY><P>Use the below option if you need to include weekends:</P><P></P><P><STRONG>Floor(PO_Approved_Date) - Floor(PO_Created_Date)</STRONG></P></BODY></HTML> Sat, 15 Mar 2014 01:03:18 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-processed-days-from-2-dates/m-p/576263#M683541 2014-03-15T01:03:18Z