Posted by Razvan Socol on 06/19/07 11:56

Hello, Rob

Try something like this:

SELECT * FROM YourTable
WHERE DATEPART(hh,StartDate) BETWEEN 8 AND 18
AND (DATEPART(w,StartDate)+@@DATEFIRST)%7 BETWEEN 2 AND 6

Razvan

[Back to original message]