Modify a DateDiff Query to Ignore Weekends?

[mkallover]

Is there a way to modify this query to ignore weekends?

SELECT Req.request_id, Req.prcs_add_tmsp, MIN(Resp.response_date) AS FirstResponse, FORMAT(DateDiff("h", Req.prcs_add_tmsp, FirstResponse)/24,"00.000") AS ResponseTime
FROM dbo_CPO_REQUEST AS Req LEFT JOIN dbo_CPO_REQUEST_RESPONSE AS Resp ON Req.request_id = Resp.request_id
GROUP BY Req.request_id, Req.prcs_add_tmsp;

 

[traingamer]

See faq181-261 as well as a number of other posts.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard