=DateDiff

[Sonya]

I need help calculating the working days between two date
fields in a form. Example: [Date Received] and the [Date
Action Taken].

The =DateDiff does not work and I was unsuccessful in
trying to create the fix provide on-line.

My form was created in Access 2000. If someone can help
me that will be GREAT.

Some please help.

Sonay

 

[Rick Brandt]

I need help calculating the working days between two date
fields in a form. Example: [Date Received] and the [Date
Action Taken].

The =DateDiff does not work and I was unsuccessful in
trying to create the fix provide on-line.

My form was created in Access 2000. If someone can help
me that will be GREAT.

DateDiff is the proper solution. What do you mean it "...does not
work..."?

 

[Rick Brandt]

I need help calculating the working days between two date
fields in a form. Example: [Date Received] and the [Date
Action Taken].

The =DateDiff does not work and I was unsuccessful in
trying to create the fix provide on-line.

My form was created in Access 2000. If someone can help
me that will be GREAT.

DateDiff is the proper solution. What do you mean it "...does not
work..."?

I missed the reference to "working days" in my first response. I suppose
you would have to use a custom function that knew your definition of
"working days" to do this. Do you just mean no weekends?

 

[Rick B]

Please do searches before posting questions. Cheryl just answered this
question in the Query group...

----------------------------------------------------------------------------
---------
Dan,

There are some really great functions for doing workday math at:

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

The first one listed in the code at that link might be just what you're
looking for.

--

Cheryl Fischer, MVP Microsoft Access
----------------------------------------------------------------------------
----------





I need help calculating the working days between two date
fields in a form. Example: [Date Received] and the [Date
Action Taken].

The =DateDiff does not work and I was unsuccessful in
trying to create the fix provide on-line.

My form was created in Access 2000. If someone can help
me that will be GREAT.

Some please help.

Sonay

 

[Cheryl Fischer]

You definitely want to use the dhCountWorkdaysA() function found (with other
excellent functions for workday math) at the following link:

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

Just copy the code found at the link into a Public Module (it is long, as
each function is heavily commented as a teaching tool), and you are "good to
go".

 

[Cheryl Fischer]

Rick,

Thanks for finding the appropriate post for the questioner.

(I'm still new enough at this MVP thing that my heart goes "pitty-pat" when
I'm quoted. <BG>)