DateDiff

R

Roger Converse

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
 
J

John W. Vinson

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

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]
 
R

Roger Converse

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
 
D

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)
 
J

John W. Vinson

I was hoping that Access had somethig for holidays.
Click to expand...

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]
 
Top