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)

[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.

JT

[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/id...

Would make this process a lot easier!

Best,

Callum

[JaredDolich]

@CallumWI upvoted that!

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

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

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

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

[Yash1]

Hi@CallumWand@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@jnooneapproach, 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