Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

regowins
Contributor II

Add week days only to a date

Hi,

How do I add only week days to a date. I am trying to set a due date but I only want business days. For example, if I do date(current_date + 10) as due_date gives me calendar days. I want the due date to show 10 week days from the current date.

Thanks!!

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Add week days only to a date

Try LastWorkDate() function:

lastworkdate(today()+1, 10)

will add 10 working days to today (not counting today itself).

2 Replies
MVP
MVP

Re: Add week days only to a date

Try LastWorkDate() function:

lastworkdate(today()+1, 10)

will add 10 working days to today (not counting today itself).

regowins
Contributor II

Re: Add week days only to a date

Great, Thanks!