DateDiff

  • Thread starter Thread starter Guest
  • Start date Start date
G

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