3 Replies Latest reply: Sep 13, 2017 11:45 AM by naveen kumar RSS

    how to convert yearmonth in to fiscal year

    naveen kumar

      Hello,

       

               Is it possible to convert the below values in to fiscal year ...

       

      CMonth

      201604

      201605

      201606

      201607

      when it come to fiscal year all the above values are FY2017

       

      Expression i tried :

                                year(addmonths(CMonth,9)) as Fiscal Year

      but i am getting any output ..

      is there any other way to write this expression

       

       

      thanks