13 Replies Latest reply on Jan 3, 2017 1:20 AM by Sireesha J

    Fiscal Year issues

    sneha simha

      Dear All

       

                            I have to change my Fiscal year from April to January and i have the formula like his for Fiscal this year and fiscal Last year but since its 2017 now my data is sgowing null values as i have no values for jan 2017.Kindly help me at the earliest .

       

      IF (YEAR([Docdate]) = YEAR(TODAY()) and MONTH([Docdate]) >=4 and MONTH([Docdate]) <=12)

      or (YEAR([Docdate]) = YEAR(TODAY())+1 and MONTH([Docdate]) <=3)

      then 'TY'

       

       

      ELSEIF (YEAR([Docdate]) = YEAR(TODAY()) and MONTH([Docdate]) <=3)

      or (YEAR([Docdate]) = YEAR(TODAY())-1 and MONTH([Docdate]) >=4 and MONTH([Docdate]) <=12)

      then 'LY'

       

       

      END

       

      Regards

      sneha