4 Replies Latest reply on Oct 12, 2018 9:22 AM by Raza Asghar

    Splicing out 2 letters in between text

    Raza Asghar

      Hi,

       

      I have a field, FYDATE, that looks like:

       

      • September FY 2019
      • March FY 2020
      • June FY 2018

       

      I'd like to create a field which outputs just the month & yr, so September 2019, March 2020, & June 2018.

       

      I was wondering if there was a function that can splice out the FY. If not, how can I combine Right & Left to achieve this? I know RIGHT(FYDATE,4) that can spit out the year, like 2019 and 2018. But how would I get the month from the left side, since the length of each month is not the same?

       

      Thank you!