Current and Previous Week, Month, Quarter, Year in SQL Server

This blog defines current and previous Week, Month, Quarter, Year in SQL Server.

DECLARE @DateFilterType NVARCHAR(MAX)

--set @DateFilterType = 'CurrentWeek'

--set @DateFilterType = 'CurrentMonth'
--set @DateFilterType = 'CurrentQuarter'
--set @DateFilterType = 'CurrentYear'
--set @DateFilterType = 'PreviousWeek'
--set @DateFilterType = 'PreviousMonth'
--set @DateFilterType = 'PreviousQuarter'
--set @DateFilterType = 'PreviousYear'

SELECT

CASE
WHEN @DateFilterType = 'CurrentWeek' THEN DATEADD(WK, DATEDIFF(WK,0,GETDATE()),0)
WHEN @DateFilterType = 'CurrentMonth' THEN DATEADD(M, DATEDIFF(M,0,GETDATE()),0)
WHEN @DateFilterType = 'CurrentQuarter' THEN DATEADD(QQ, DATEDIFF(QQ,0,GETDATE()),0)
WHEN @DateFilterType = 'CurrentYear' THEN DATEADD(YY, DATEDIFF(YY,0,GETDATE()),0)
WHEN @DateFilterType = 'PreviousWeek' THEN DATEADD(day, -7 ,DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0))
WHEN @DateFilterType = 'PreviousMonth' THEN DATEADD(month, -1, DATEADD(M, DATEDIFF(M,0,GETDATE()),0))
WHEN @DateFilterType = 'PreviousQuarter' THEN DATEADD(QQ, DATEDIFF(QQ,0, Dateadd(ms,-6,Dateadd(qq, Datediff(qq,0,GetDate()), 0))),0)
WHEN @DateFilterType = 'PreviousYear' THEN DATEADD(YY, DATEDIFF(YY,0,DATEADD(year,-1,GETDATE())),0)
END AS [StartDate]

,CASE
WHEN @DateFilterType = 'CurrentWeek' THEN GETDATE()