by ssi
27. September 2016 15:48
set@StartDate= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())-1, 0)--First day of previous month
set@EndDate =DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE())-1, -1) --Last Day of previous month
end
else
begin
set@StartDate=dateadd(dd,((datediff(dd,'17530101',getdate())/7)*7)-7,'17530101') -- Date greater than or equal to Monday of last week
set@EndDate =dateadd(dd,((datediff(dd,'17530101',getdate())/7)*7)-2,'17530101') -- Date before Saturday of last week
c53b3c31-00fb-4497-854e-ca0be26ec9c6|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags: SQL, DATE
SQL