Home Forums SQL Server 2005 T-SQL (SS2K5) Set fiscal year, have year automatically roll over RE: Set fiscal year, have year automatically roll over

  • February 23, 2012 at 9:09 am

    #1450939

    DECLARE @MyDate DATETIME SET @MyDate = getDate()

    DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME

    SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, @MyDate)) - 4)%12), @MyDate ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, @MyDate)) - 4)%12),@MyDate ))+1 ) ) SET @EndDate = DATEADD(ss,-1,DATEADD(mm,12,@StartDate ))

    SELECT @StartDate,@EndDate