Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to get the processed days from 2 dates?

Hi,

How can I get the duration of processing from two dates?

From PR Approved date to PO creation date including the weekend?

Thanks a lot!!

Regards,

Ahyel

8 Replies

Re: How to get the processed days from 2 dates?

Use Below Function...
=NetWorkDays(StartDate, EndDate)

Or

=Interval(EndDate-StartDate,'D')

marcus_malinow
Valued Contributor III

Re: How to get the processed days from 2 dates?

Alternatively

num(PR Approved Date) - num(PO creation date)

rustyfishbones
Honored Contributor II

Re: How to get the processed days from 2 dates?

Try

[PO Creation] - [PR Approved]

rustyfishbones
Honored Contributor II

Re: How to get the processed days from 2 dates?

Or like Manish said

2014-03-14_1120.png

Not applicable

Re: How to get the processed days from 2 dates?

Hi,

Networkday excludes weekends right? How to include weekends in the count?

Thank you

manojkulkarni
Valued Contributor II

Re: How to get the processed days from 2 dates?

NetWorkdays() : Returns the number of working days (Monday-Friday).

Better to use Interval(Enddate-StartDate,'D')

Re: How to get the processed days from  2 dates?

use my second option.

Not applicable

Re: How to get the processed days from 2 dates?

Use the below option if you need to include weekends:

Floor(PO_Approved_Date) - Floor(PO_Created_Date)

Community Browser