Date Diff

[SageOne]

Is there a function that calculates the date diff between two dates but
discounts weekends?

Basically I need to calculate the business day date diff.

 

[Douglas J. Steele]

Take a look in the Date/Time section of "The Access Web"
http://www.mvps.org/access/

 

[Daniel Pineault]

Take a look at http://www.mvps.org/access/datetime/index.html for all your
date/time questions, specifically at:

http://www.mvps.org/access/datetime/date0006.htm
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Steve]

Your post does not mention it but do you want to discount holidays too?

Steve
(e-mail address removed)

 

[pietlinden]

Your post does not mention it but do you want to discount holidays too?

Steve
(e-mail address removed)

that one is on Arvin's web page, www.datastrat.com , in the sample
code section. ... dig around a little and you'll find it.

 

[SageOne]

Found that code.....that for you help guys......Yes, I would like to also
exclude holidays....is there a way to specify the holidays? Some holidays
are not observed for the purposes of my report.

 

[John W. Vinson]

Found that code.....that for you help guys......Yes, I would like to also
exclude holidays....is there a way to specify the holidays? Some holidays
are not observed for the purposes of my report.

And of course different companies and countries celebrate different holidays.
The typical solution is to have a Holidays table with one record for each
holiday date. Check the websites again, most published solutions have a
Holidays table and use it in the calculation.