DateRanges.sql

DECLARE @Now date = GETDATE()
SELECT
	@Now AS [Today],
	DATEADD(MONTH, DATEDIFF(MONTH,0,@Now)-0, 0) AS [Current_From],
	DATEADD(DAY,-1,DATEADD(MONTH, DATEDIFF(MONTH,0,@Now)+1,0)) AS [Current_To],
	
	DATEADD(MONTH, DATEDIFF(MONTH,0,@Now)-1, 0) AS [LastMonth_From],
	DATEADD(DAY,-1,DATEADD(MONTH, DATEDIFF(MONTH,0,@Now)+0,0)) AS [LastMonth_To],

	DATEADD(MONTH, DATEDIFF(MONTH,0,@Now)-2, 0) AS [LastMonth2_From],
	DATEADD(DAY,-1,DATEADD(MONTH, DATEDIFF(MONTH,0,@Now)-1,0)) AS [LastMonth2_To],

	DATEADD(MONTH, DATEDIFF(MONTH,0,@Now)-12, 0) AS [LastYearMonth_From],
	DATEADD(DAY,-1,DATEADD(MONTH, DATEDIFF(MONTH,0,@Now)-12,0)) AS [LastYearMonth_To]