Date minus date in working days?

[Harmannus]

Hallo,

Is it possible to manipulate the outcome of a data substraction with
workingdays?

E.g.

30-01-2005 (=date()) minus 20-01-2005 (=fldDate) is 10 days. Between
30-01-2005 and 20-01-2005 is a weekend (saterday/sunday). So the outcome
should be 8.

Can the outcome of 8 be generated through code?

Thanx for any tips!

Regards,
Harmannus

 

[Rick B]

asked and answered all the time. Did you try searching for your answer?

Search for "work days" or "business days".

 

[Douglas J. Steele]

Take a look in the Date/Time section of "The Access Web" for a couple of
solutions.

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