DECLARE @FISCALDATE DATE
DECLARE @ENDDATE DATE
SET @ENDdate = '02/01/2012'
SELECT CASE
WHEN DATEPART(MM, @ENDdate) <= 6 THEN CONVERT(DATETIME, '01-' + '07-' + CAST((DATEPART(YY, @ENDDATE) -1) AS CHAR(4)), 103)
--DATEPART(YY, @ENDDATE) -1
ELSE CONVERT(DATETIME, '01-' + '07-' + CAST((DATEPART(YY, @ENDDATE) -1) AS CHAR(4)), 103)
END AS fiscalDATE
But it might be simpler to do it this way:DECLARE @ENDDATE DATE
SET @ENDdate = '02/01/2012'
SELECT DATEADD(mm,(DATEDIFF(mm,0,@ENDdate)-6)/12*12+6,0) AS fiscalDate
DAte conversion
Posted - 02/14/2013 : 13:35:12
