6 Replies Latest reply on Mar 26, 2020 10:56 AM by kevin flerlage

    HELP: How to convert fiscal date (calculated field required)

    Frank Bush

      Hi anyone knows how do I convert fiscal name with format like that?

       

      As example, I want to convert below: (Note: for periods with 10, 11, 12 will be as is, only 1-9 will add 0 after "P")

       

      • "FY2019-P1"  into "FY19-P01"
      • "FY2020-P9" into "FY20-P09"
      • "FY2020-P10" into "FY20-P10"

       

       

         SO BASICALLY ALL P1-P9 SHALL BE P01-P09 THEN P10, P11, P12 will be as is.

       

      then FY + "last two digits of fiscal year"