Home Forums Reporting Services Reporting Services 2008 Development Converting calendar date into fiscal year RE: Converting calendar date into fiscal year

  • March 25, 2014 at 2:15 pm

    #1700056

    Here is a SQL way to do this easily:

    declare @Date date = '20140201';

    select cast(YEAR(dateadd(month,9,@Date))-1 as varchar(4)) + '-' + cast(YEAR(dateadd(month,9,@Date)) as varchar(4))

    set @Date = '20140612';

    select cast(YEAR(dateadd(month,9,@Date))-1 as varchar(4)) + '-' + cast(YEAR(dateadd(month,9,@Date)) as varchar(4))