Hi there I was wondering how do you convert 2/3/2020 (which is a date format) to 2/3/2020 ( a text format)
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
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
@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...
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
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
Try using the Name(Date Line item), it will return as text.
@rishi8118 Date line item is a Date format and NAME() will convert an list item or list format Line Item to text.
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?