Viewing post 1 (of 2 total)
Try modifying the select to the following:
SELECT GETDATE()-(DATEPART(dw,GETDATE())+2) % 7
This should return the correct Thursday for both Friday and Saturday.
August 13, 2007 at 8:02 am
#726444