Home Forums SQL Server 2012 SQL Server 2012 - T-SQL DATEADD RE: DATEADD
Phil Parkin
SSC Guru
Points: 247210
More actions
May 28, 2014 at 4:51 am
#1716957
Yes - add it to the WHERE bit:
WHERE [existing conditions]
AND STAGE1.[STAGE.Completion_Date] > dateadd(d,-7,getdate())