J
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.
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.