Hi Paul,

When I got rid of the 1 at the end of the statement it worked for me.

Try

declare @dt datetime

select @dt=getdate()-28

...