Hello everyone.

I need to determine if a dynamic date is in a specified date range.

For example, I have 1 initial start date, then during the cours of the application, I add x amount of weeks / x amount of months to it, until it reaches the specified end date. - This all works fine.

What I have to do now, is to compensate for a 3 week leave period ( the last 2 weeks of dec and the first week of jan ). because of the 3 week break period, I need to add the "extra" 3 weeks to the current dynamic date in that range.

Can anyone please give me an idea, perhaps example on how I should go about doing this?


I'm alread using DateAdd to add the weeks / months. What I'm battling with is to determine the 3 weeks leave period.

For example, say I have been adding the dates and everything goes well.
Let us also realise that the 3 week break period starts the 15th december ( which may differ depending on input).

So now, after I have added the date, and I see that this date is between 15 december and 5 january, I have to add an additional 3 weeks to it,

how would I do this?

Thank you.