SQL Server 2000 Working Days

[TheUnderTow]

Does anybody know a statement to enable me to amend the amount of days back a query will look depending on whether it is a monday or any other day of the week - on a monday it will need to look for entries over the weekend whereas during the week it will just be 1 day beforehand (i.e. GETDATE()-1)

[OBonio]

A combination of CASE .. WHEN, DATEPART and GETDATE

WHERE DateField > CASE DATEPART(dw, GETDATE()) WHEN 2 THEN DATEADD(dd, -3, GETDATE()) -- It's a Monday!
ELSE GETDATE(dd, -1, GETDATE()) -- It's another day of the week