how to convert date to text

Highlighted
Occasional Contributor

how to convert date to text

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

5 REPLIES 5
Highlighted
Master Anaplanner/Community Boss

Re: how to convert date to text

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

Highlighted
Master Anaplanner/Community Boss

Re: how to convert date to text

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

Highlighted
Master Anaplanner/Community Boss

Re: how to convert date to text

@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%2...

 

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

 

 


Jared Dolich
Highlighted
Frequent Contributor

Re: how to convert date to text

Hi @CallumW and @Jared Dolich ,

 

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

Highlighted
Certified Master Anaplanner

Re: how to convert date to text

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