I'm currently calculating "Month to Date" & "Year to Date" sales however I need to calculate "Week to Date" where my week begins on a Sunday.
Here is how I'm calculating the MTD & YTD
SELECT Period_End_Date AS MthEndDate ,
DATEADD(mm, DATEDIFF(mm, 0, Period_End_Date), 0) AS MthStartDate ,
DATEADD(yy, DATEDIFF(yy, 0, Period_End_Date), 0) AS YearStartDate ,
DATEADD(yy, DATEDIFF(yy, 0, Period_End_Date) + 1, -1) AS YearEndDate
FROM [KLL AR Periods - Vertical]
WHERE ( AR_Period = '201607' );
What do I need to add to this to get WkStartDate & WkEndDate?