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.

Any help is much appreciated, Thanks.

 

[Jeff Boyce]

If you know the date received, why do you need to store the [DTE_TO_SCH]?

Why not use a query to do that calculation on the fly? You could also use a
query to get your "countdown" info.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.