Convert date type to period


Hi All,

I converted this date format into period using this formular

PERIOD(DATE(VALUE(RIGHT(Reporting Period, 4)), VALUE(LEFT(Reporting Period, 2)), 1))

How can this date format be converted to period in Anaplan just like above. It doesn't work with the formula above. Please is there a workaround on converting this to period format.

Best Answer

  • HimanshuRaj
    Answer ✓

    Hi @innocent

    You can also use below formula to convert text month to time formatted month list

    FInditem(TIME, substitute(reporting period, "-"," "))