3 Replies Latest reply: Jun 2, 2016 12:36 AM by Joyson Joy RSS

    how to write expression

    naveen kumar

      Hello  All,

       

      this is my expression to get  financial year ,which is working great

       

       

      'FY'&year(AddYears(yearstart (ENSTEHDAT, 1, 4),-1)) &'-'&Year(yearstart (ENSTEHDAT, 1, 4)) as Year


      this is what i am getting

       

      ESTEHDAT           Year

      10/29/2003           FY2003-2004

       

      what i am looking is this

       

      ESTEHDAT           Year

      10/29/2003           FY03-04


      how to get only two values from year fiels