Calculating week end date - always a Monday

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to have Access fill a field with a date that is calculated to
the following Monday of the date entered?

for example. I type in 06/01/05, then access calculates and replaces that
date with 06/01/05, the Monday FOLLOWING that date.

Thanks

Steve
 
Is there a way to have Access fill a field with a date that is calculated to
the following Monday of the date entered?

for example. I type in 06/01/05, then access calculates and replaces that
date with 06/01/05, the Monday FOLLOWING that date.
Click to expand...

Try:

DateAdd("d", 8 - Weekday([entereddate], 2), [entereddate])

The 2 in the Weekday function specifies that your week begins on
Monday; so if the entered date is a Tuesday, Weekday() will return 2
(the day after Monday). DateAdd will then add 6 days to the
entereddate and return the next Monday.

John W. Vinson[MVP]
 
Back
Top