DateDiff

[Guest]

Is there a way to calclate business dates between two dates without counting
weekends or holidays? Ir eally don't want to have to update a table every
year if possible.

Thanks,
Roger

 

[Guest]

Take a look at

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

it should be what you are looking for.

 

[John W. Vinson]

Ir eally don't want to have to update a table every
year if possible.

Then you will need to create a table for the movable holiday dates in every
year that you expect the application to be in operation. You can certainly
program to have December 25th as a holiday (if your company observes
Christmas); but other variable holidays - Mondays after a Sunday holiday, say
- may be harder to calculate.

IOW there is nothing built in to Access which identifies a date as "a date
that your company observes as a holiday" - you have to provide that
information!

John W. Vinson [MVP]

 

[Guest]

Thanks!

John, I was hoping that Access had somethig for holidays. With the weekends
taken care of, updating a table once a year is no big deal.

Thanks again.

Roger

 

[Douglas J. Steele]

See whether my June, 2005 "Access Answers" column in Pinnacle Publication's
"Smart Access" (a followup to the September, 2004 column) helps. You can
download the columns (and sample databases) for free from
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

 

[John W. Vinson]

I was hoping that Access had somethig for holidays.

Well... it can't.

My local Islamic Center observes Eid ul-Fitr and Eid ul-Adha as holidays
(among others); they don't observe Easter Monday or Christmas Day. Columbus
Day might be observed as a holiday in Massachusetts; it's not in Idaho. Each
company has its own definition of what's a "holiday" and it's frankly
unreasonable to expect Access to magically intuit your particular set of days!

John W. Vinson [MVP]