Convert date type to period

innocent

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.

HimanshuRaj

Hi @innocent

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

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

Cheers!!

rob_marshall

@innocent

Instead of loading in as text, change the format of the line item to Time Period.

innocent

Thanks @rob_marshall it is a Master Data Module with no time dimension.

So when I had the format to Time Period Month and import it throws this error to me

innocent

Thanks a lot @Himanshu1998 that did the trick.