Date Differences based on Weekdays

[puforee]

I am running a query that needs the difference between two dates calculated for just work days. Weekends should be ignored.

Help!

 

[Remou]

This has come up in several posts, also, there are FAQS, for example:

faq702-4851

 

[puforee]

Remou,

Thanks, I read the FAQ but that is for a Form. I need it for a Query.

 

[Remou]

You will need to use a function (UDF) in the query, the FAQ shows the basis for such a function.

 

[PHV]

Have a look here:

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

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886