Date field question
Thank you!
"fredg" wrote:
On Wed, 1 Jul 2009 13:39:01 -0700, Bob Waggoner wrote:
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
Add 2 days if the resulting date is a Saturday, add 1 day of the
resulting date is a Sunday.
Perhaps this will help:
DueDate: IIf(Weekday([ADate]+[FreqDays])=7,([ADate]+[FreqDays])+2,
IIf(Weekday([ADate]+[FreqDays])=1,([ADate]+[FreqDays])+1,[ADate]+[FreqDays]))
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
|