SELECT * FROM orderflow.[Order]
WHERE DATEDIFF(dd,CreateTime,GETDATE())<=70
SELECT * FROM orderflow.[Order]
where CreateTime<=DATEADD(dd,-7,GETDATE())
SELECT * FROM orderflow.[Order]
WHERE DATEDIFF(dd,CreateTime,GETDATE())<=70
SELECT * FROM orderflow.[Order]
where CreateTime<=DATEADD(dd,-7,GETDATE())