=DateDiff

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

Sonya

I have created a form in Access 2000 in which I need to
calculate the work days between two fields; example,
[Date Received] and [Date Action Taken].

My understanding that there is a glick in the =DateDiff
in Access 2000.

Can someone please help me?

Sonya
 
I have created a form in Access 2000 in which I need to
calculate the work days between two fields; example,
[Date Received] and [Date Action Taken].

My understanding that there is a glick in the =DateDiff
in Access 2000.

Can someone please help me?
Click to expand...

If by a "glick" you mean that it doesn't know workdays from weekends,
you're right; as documented, it works fine. =DateDiff("d", [Date
Received], [Date Action Taken]) will return the number of calendar
days between those two dates.

There is no builtin "workdays" function. You'll need - at the least -
a table of the holidays which your company observes and some VBA code
to check for them, and for weekends. For some sample code see
http://www.mvps.org/access/datetime/date0012.htm
 
Back
Top