Hi,
I have a new for 2 dates in my SQL stored procedure.
1) 7 Days prior to today
2) 30 days in the future from today.
I am using these, but they don't seem to be working:
DECLARE @7daysago DATE = CONVERT(DATE, DATEADD(DAY, -DAY(GETDATE()) -7, DATEADD(MONTH, 1, GETDATE())));
DECLARE @30daysinfuture DATE = CONVERT(DATE, DATEADD(DAY, -DAY(GETDATE()) +30, DATEADD(MONTH, 1, GETDATE())));
Could anyone please point me in the right direction?
cheers