Number of working days between to dates 1

[8177]

Hi Guys

Does anybody have a idea how i can calculate the number of working days between two dates in a query

 

[lespaul]

quick check of the FAQ area of this access forum found this one:

FAQ181-261

I know there are several other techniques in the other Access fora FAQ areas, try:

Forum701
Forum700


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[8177]

Thanks lespaul

faq181-261 works a treat many thanks for your help

 

[mp9]

For later versions of Access try DateDiff, e.g.

DateDiff("w", StartDate, EndDate)

For older version of Access try the function at

http://www22.brinkster.com/accessory/modules/003.shtml

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=288194

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[leslie746]

Hi 8177,

You might try the following thread: 181-416139.

It works beautifully for me.

Good Luck