DECLARE @testdate datetime SET @testdate = DATEADD(MONTH,-2,CURRENT_TIMESTAMP ) SELECT CASE WHEN RIGHT(CONVERT(VARCHAR(10), @testdate, 112) ,4) >'1001' THEN CONVERT(datetime,LTRIM(YEAR(@testdate)-4) + '1001') ELSE CONVERT(datetime,LTRIM(YEAR(@testdate)-5) + '1001') END