How many days between dates EXCLUDING weekends 1

[Stoffel24]

Is there a way of determining the number of days between 2 dates excluding the weekends? A lab receives samples. They have 2 working days to complete the sample. I wish to determine how long it has taken them to complete the work.

Eg
Select sample_number, date_recieved, date_completed, datediff(dd,date_recieved, date_completed) (Syntax not checked here!) from sample

This simply returns the number of days between the dates. I now need to substract the number of days in this bunch that are weekends.

Thanks for the help.

 

[MaffewW]

if your using sql2k here is a function

http://www.mssqlcity.com/FAQ/Devel/get_working_days.htm

or another way check faq183-2968

Matt

Brighton, UK