Due date and count down

[Jery J.]

I have been trying many differnent codes/expessions within a query to setup a
database field [DTE_TO_SCH] that will provide a due date 10 working days from
the date entered by the user in [DTE_IC_RECVD] field. I can get it to display
10 days from date entered but it includes the non-business days as well.

I also need to provide a countdown as to how many working days a user has
left until Due date in another field; such as 5 days for remaining or -5 days
for over. I guess this second problem would be easy to answer if i knew the
answer for the first one. My biggest problem is formatting it for working
days.

How can i set it up to display the target due date (workingdays only) [it
doesn't really matter if holidays are counted]

Any help is much appreciated, Thanks.

 

[Daryl S]

Jery -

If you don't care about holidays, then I assume a work week is 5 days? If
so, you can use DateDiff and DateAdd functions to count the weeks, and
multiply those by 5 to get the days. Here are the samples:

Due Date = DateDiff("ww",DateAdd("ww",2,[Contract Date]),Now())

Days Over = 5*(DateDiff("ww",DateAdd("ww",2,[Contract
Date]),Now()))+Weekday([Contract Date])-Weekday(Now())

Hope that helps!