topic Add networkdays (working days) to an existing date in QlikView

Add networkdays (working days) to an existing date

Wed, 10 Nov 2010 14:08:08 GMT

Hi there

I have a field called (DocDate).

How can I add 10 working days (networkdays) to this date given by (DocDate)?

Thank you

Add networkdays (working days) to an existing date

danielrozental — Wed, 10 Nov 2010 15:10:46 GMT

It can probably can be improved

if(weekday(Date+10+(10-Networkdays(Date,Date+10)))=0,Date+10+(10-Networkdays(Date,Date+10))+1,

if(weekday(Date+10+(10-Networkdays(Date,Date+10)))=5,Date+10+(10-Networkdays(Date,Date+10))+2,

Date+10+(10-Networkdays(Date,Date+10))

)

Add networkdays (working days) to an existing date

danielrozental — Wed, 10 Nov 2010 15:19:35 GMT

Much simpler

Date + 10 +

if(weekday(Date)=6,2,

if(weekday(Date)=0,1,

3))

Add networkdays (working days) to an existing date

wimzjeraar — Wed, 10 Nov 2010 15:47:36 GMT

There's a function for this in QlikView:

lastworkdate( start_date, no_of_workdays {, holiday} )

Returns the earliest ending date to achieve number_of_workdays (Monday-Friday) if starting at start_date taking into account any optionally listed holidays. Start_date and number_of_workdays should be valid dates or timestamps.

Examples:

lastworkdate ('2007-02-19', 9) returns '2007-03-01'
lastworkdate ('2006-12-18', 8, '2006-12-25', '2006-12-26') returns '2006-12-29'

Add networkdays (working days) to an existing date

johnw — Thu, 11 Nov 2010 01:13:30 GMT

Lastworkdate() may be all you need. If it's not enough, I have and can post a couple examples that may help. One loads the holiday list from a table instead of requiring you to type them all in the expression. Another deals with cases where you might work on a weekend day, so want to include some of them. Both may be more complicated than you require.

Add networkdays (working days) to an existing date

Thu, 11 Nov 2010 08:39:32 GMT

Thanks guys.

It worked perfectly. It gave me exactly what I wanted. It gave me a duedate that is generated by taking the document date & adding 10 working days. I used the following in my script.

lastworkdate

(DocDate,10) as PODueDate

Re: Add networkdays (working days) to an existing date

yanivbm88 — Tue, 01 Aug 2017 13:42:25 GMT

Hi Wim,

How would you set which weekdays should be referred as working days?

I understood the default is Monday-Saturday, but how can I change it to Sunday-Friday?

I tried modifying FirstWeekDay attribute with no success.