Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DateDiff

1 view
Skip to first unread message

Roger Converse

unread,
Nov 19, 2007, 12:34:01 PM11/19/07
to
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

Daniel Pineault

unread,
Nov 19, 2007, 12:50:02 PM11/19/07
to
Take a look at

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

it should be what you are looking for.
--
Hope this helps,

Daniel Pineault

John W. Vinson

unread,
Nov 19, 2007, 3:53:43 PM11/19/07
to
On Mon, 19 Nov 2007 09:34:01 -0800, Roger Converse
<RogerC...@discussions.microsoft.com> wrote:

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

Roger Converse

unread,
Nov 20, 2007, 3:49:03 PM11/20/07
to
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

unread,
Nov 20, 2007, 5:24:23 PM11/20/07
to
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
http://I.Am/DougSteele
(no private e-mails, please)


"Roger Converse" <RogerC...@discussions.microsoft.com> wrote in message
news:87E03353-7019-4355...@microsoft.com...

John W. Vinson

unread,
Nov 20, 2007, 8:40:11 PM11/20/07
to
On Tue, 20 Nov 2007 12:49:03 -0800, Roger Converse
<RogerC...@discussions.microsoft.com> wrote:

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

0 new messages