Discussion Board for collaboration on QlikView Scripting.
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!!
Use Below Function...=NetWorkDays(StartDate, EndDate)
num(PR Approved Date) - num(PO creation date)
[PO Creation] - [PR Approved]
Or like Manish said
Networkday excludes weekends right? How to include weekends in the count?
NetWorkdays() : Returns the number of working days (Monday-Friday).
Better to use Interval(Enddate-StartDate,'D')
use my second option.
Use the below option if you need to include weekends:
Floor(PO_Approved_Date) - Floor(PO_Created_Date)