Add 7 days to date but also 14 days

[Ben]

I have a date field on my database called End Date:

The End Date is the friday of each week. I want to be able to have the
database automatically add 7 days to the friday date each week for 3 weeks
only.

The fourth week of the month has no activity in the database. I want the
database to "see" there is a break from week 3 to week 4 and add 14 days to
the End Date.

Is this possible?
Ben

 

[Jeff Boyce]

Ben

It isn't clear whether you are trying to modify the [EndDate] (a bad idea!)
or merely trying to display a newly-calculated value (a better idea!).

If the latter, use a query to find [EndDate] values within three weeks of
the current date, then add as much as you need. Check the DateDiff(),
Date(), DateAdd() and IIF() functions...

Regards

Jeff Boyce
Microsoft Office/Access MVP