Target Due date and countdown for working days

[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; 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 the field to display the target due date (workingdays only)?
It doesn't really matter if holidays are counted.

Any help is much appreciated, Thanks.

 

[Douglas J. Steele]

Check the Date/Time section of "The Access Web"

http://www.mvps.org/access/DateTime/

There are a couple of possible solutions there.

You could also check my September, 2004 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html