>>We need to know the number of "business days" between two dates. Does anyone know a function or routine that will do this. For example, Monday August 9 - Friday August 6 would equal 1 "business day".
>>
>>Thanks for the help.
>>Doug
>
>You're going to have a tough time with this one because of the differing definitions of "business day". Is Christmas a business day?

Like Erik said there are alot of pitfalls, but you can start with a case statement that checks CDOW().