Add workday to datetime

[#1]

Hello,

I'm searching for a function or solution to add a variabel amount of workdays to another variabele datetime. I see functions as FirstWorkDay, Lastworkday and netWorkDay but neither of them is the solution for me.

For example: 06/28/2011 + 5(days) =  07/05/2011. How can i do this in Qlikview?

Thanks!

[Anonymous]

If your date is recognized as a proper date (i.e. it has an underlying numeric value) in your document it's as easy as: Date(DATEFIELD +5) as DATEFIELDPlus5

[#3]

Hello Johannes,

Thanks for your quick reply.

I want to add a number of workdays not just days. I mentioned this in the title and in de example but forgot to mention "work" in the body i changed it.

[Anonymous]

Ah, sorry about that Michel. Was reading too quickly and missed that part. Hm, that's trickier. Basically you're trying to figure out how many days to add to get a NetWorkDays() addition of 5 days. I'll see if I can come up with anything

[nagaiank · Accepted solution]

If you want to add 'N' work days, will the function LastWorkDate(startdate,N+1) work for you?

[#6]

This is exactly what i needed. It just generate a date based on adding N workdays. I looked for this kind of function but couldn't find it. Now i have! Thanks!