Hello everyone,Is there any possibility of converting line item formatted as period (Month) into the TEXT?Thank you
@musoresempaul
Great question. There is a great function you can use called "NAME" that will work.
For all conversion types you can reference this webpage.
https://help.anaplan.com/debe3d05-0303-4403-ab3e-bf0046852a2c-Convert-between-Data-Types
Hi,
Like Jared mentioned, Name is the function to go to.
Time basically works like any other list, so you could use Name(Item(TIME)).
The output of Item(TIME) would be the same as Jareds Period(Start()).
As always - lots of ways to get the same output.
Good luck 🙂
Ultimately, it depends how you want to format the final output.
As of today, Anaplan does not provide a function to convert a date to text in a specific format. There is an Idea posted to the Idea Exchange here: https://community.anaplan.com/t5/Idea-Exchange/New-Function-To-Convert-Date-Format-to-Text-Format/idi-p/53134
@JaredDolich and @Noward both suggested a viable approach with using the NAME() function. Note, however, that this will display the date in the same format it would be displayed in had you not used the NAME function (i.e. Anaplan already essentially uses the NAME in the backend to display list items).
If you want a specific date format associated with each month item, you would need to convert it to a date, and then use a series of functions to convert each portion of the date to text and concatenate them together. However, note that using text is NOT advised and is against Anaplan best practices (see Planual rules 2.02-04 and 2.03-02).
If you do need to convert month periods to text-formatted dates, be sure to do this in a System module dimensioned only by Time (Month).
For approaches to formatting dates, I'd recommend checking out these other Community posts that provide good advice:
Thank you @JaredDolich & @ryan_kohn and @Noward for your contribution,now I do well understand data conversion based on your support
I was able to go with this.Regards,Sem
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
