topic Add workday to datetime in QlikView

Add workday to datetime

Tue, 28 Jun 2011 06:48:56 GMT

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!

Add workday to datetime

Anonymous — Tue, 28 Jun 2011 06:59:29 GMT

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

Add workday to datetime

Tue, 28 Jun 2011 07:04:32 GMT

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.

Add workday to datetime

Anonymous — Tue, 28 Jun 2011 07:11:30 GMT

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

Re: Add workday to datetime

nagaiank — Tue, 28 Jun 2011 08:43:22 GMT

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

Add workday to datetime

Tue, 28 Jun 2011 09:09:10 GMT

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!