I am developing an Access application using Access 2003. Is there a routine/function to calcuate the number of business days between 2 dates?

I am developing an Access application using Access 2003.

In my application, I perform an age calculation based on the difference between 2 date fields.

Is there a routine/function to calcuate the number of business days between 2 dates?

I am trying to avoid counting weekends and holidays.
zimmer9Asked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
See these links:

http://support.microsoft.com/kb/210064

http://www.mvps.org/access/datetime/date0006.htm

You will need to have a Holiday table (among other things) related to your specific needs.

This might help you with the holiday part.  Also not the posts by cactus_data.

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23477598.html#a21767207

mx
0
 
Luke ChungConnect With a Mentor PresidentCommented:
I remember doing this for an international bank that had to find dates when banking institutions were open on the same day in all the countries involved in a transaction. We had lists of holidays by country. Who knew that some countries are closed on every full moon?

We have a commercial VBA module source code library, Total
Visual SourceBook, that has as one of its classes, Business Day Math: http://www.fmsinc.com/microsoftaccess/modules/code/general_vba_vb6_date_and_time_cbusinessdatestable.htm

There are related Date/Time functions here which are free: http://www.fmsinc.com/Products/sourcebook/SampleCode.htm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.