=DateDiff

  • Thread starter Thread starter Sonya
  • Start date Start date
S

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
 
Sonya said:
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.
Click to expand...

DateDiff is the proper solution. What do you mean it "...does not
work..."?
 
Rick Brandt said:
Sonya said:
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.
Click to expand...

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

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?
 
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
 
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".
 
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>)
 
Back
Top