Date field question
Thanks, Jeff. I've taken your advice and added them to my favorites list. I
Appreciate the help.
Bob
"Jeff Boyce" wrote:
Here in the USA, this coming Friday is an observed holiday. How would you
want the function/routine to handle that?
Some holidays are observed on a Monday. How would you want the
function/routine to handle that?
Consider taking a look at mvps.org/access to see about a WorkDays()
function -- it may offer ideas toward what you're working on.
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Bob Waggoner" wrote in message
...
I have PMs that are due - sometimes within 1 day and sometimes within 3
days.
I record the date done and have a query extract the next due date. When
that
falls on a weekend, how do I get the date to advance to the following
Monday
for a due date? Here's my code now.
Due Date: (([MaxOfDateDone]+[FreqDays]))
Thanks
|