Due date Workdays

[pcdoc32]

Hello Everyone and Thank you in advance!!!

I need to create a field or query that will calculate the due date of a document.
Example I completed this for and its due in 10 working days.
So from the date originated field [Date] and due date is [Due Date]
How to have access calculate 10 working days from the originated date.

Thank you

 

[boblarson]

1. Rename your field DATE to something else. That is an Access Reserved word and is one that it really gets sticky if you continue to use as a field name.

2. You can use the DateAdd function to get the due date in a query. (the syntax is here on the site and in the help file). (EDIT - SEE RG's Post below for a more appropriate answer to this part)

 

[RuralGuy]

Search this site for Workday.

 

[raskew]

Hi -

Take a look at http://www.access-programmers.co.uk/forums/showthread.php?t=159719&highlight=upbusdays3 Post #3.

HTH - Bob