topic Re: forcing weekends or holidays into lastworkdate() in QlikView

forcing weekends or holidays into lastworkdate()

Wed, 21 May 2014 08:50:12 GMT

Hello

I have a start date, [number of working days] and need to calculate the end date whilst resppecting the working days betwwen 'startDate' and 'startDate+ [number of working days]'. the function lastworkdate() only calculates the earliest ending date to acheive number_of_workdays (Monday-Friday) the thing is i can have some workdays on saturdays or sundays too , and that function would not take them into account. is there any work arround for this?

you will find an example in the attached image in case if saturday 24th is a working day

thank you in advance for your help

Re: forcing weekends or holidays into lastworkdate()

swuehl — Wed, 21 May 2014 10:33:23 GMT

I don't think you can tweak lastworkdate() to achieve what you want, but maybe by creating a calendar where you flag the working days, then assigning a consecutive working day number.

Retrieving the end date would then indeed just adding number of days to working day number of the start date.

Re: forcing weekends or holidays into lastworkdate()

tresB — Wed, 21 May 2014 11:26:41 GMT

See the attachment- an atlernate method. Used expression:

=Date(If(WeekDay(Date+vLastWorkingDateParam-1)>=5,Date+vLastWorkingDateParam-1,LastWorkDate(Date,vLastWorkingDateParam)))

You might have to modify according to user date system.