Convert date type to period

Monpero

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.

Monpero

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

Monpero

Thanks a lot @Himanshu1998 that did the trick.

seymatas1

@Monpero

Add a time dimension to the master data module.

Refer to this article by @rob_marshall

https://community.anaplan.com/discussion/48866/oeg-best-practice-data-hubs-purpose-and-peak-performance