nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to convert date to text

Jmanaplanner46

Hi there I was wondering how do you convert 2/3/2020 (which is a date format) to 2/3/2020 ( a text format)

Accepted answers

jnoone

Hey - Can you try the below replacing "Date Format" with your date formatted line item:

TEXT(MONTH(DATE FORMAT)) & "/" & TEXT(DAY(DATE FORMAT)) & "/" & TEXT(YEAR(DATE FORMAT))

Thanks.

All comments

jnoone

Hey - Can you try the below replacing "Date Format" with your date formatted line item:

TEXT(MONTH(DATE FORMAT)) & "/" & TEXT(DAY(DATE FORMAT)) & "/" & TEXT(YEAR(DATE FORMAT))

Thanks.

CallumW

Just thought it would be relevant to share this idea;

https://community.anaplan.com/t5/Idea-Exchange/New-Function-To-Convert-Date-Format-to-Text-Format/idi-p/53134

Would make this process a lot easier!

Best,

Callum

JaredDolich

@CallumW I upvoted that!

Surprisingly, @jnoone suggestion is not even mentioned on the data conversion Anapedia page.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/Function%20Usage/Convert%20between%20Data%20Types.htm

I can't tell you how often I have to make this conversion.

@Jmanaplanner46 just make sure you make that conversion in a system module. Calculate once, reuse often...

Yash1

Hi @CallumW and @JaredDolich ,

I have upvoted this too!

I agree that how many times we need to do this.

It would simply things if we have a direct solution to this.

Cheers,

Yash

andre.lie

Hi @Jmanaplanner46 ,

Almost similar to @jnoone approach, if it is required for the date and month to be in 2 digits, I usually convert the date to number using formula

YEAR(DATE FORMAT) * 10000 + MONTH(DATE FORMAT) * 100 + DAY(DATE FORMAT), and then convert it to text format using TEXT and MID functions.

Regards,

Andre

rishikesh.shukla

Try using the Name(Date Line item), it will return as text.

VikaSPatil

@rishi8118 Date line item is a Date format and NAME() will convert an list item or list format Line Item to text.

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan Toolkit: side panel for model details, exports and model lock tracking
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…
How to handle an Entity Structure change effective from January 2026 in Anaplan Consolidation & Repo
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…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
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…