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.
Can someone help me i am unable to login anaplan portal using my credentials
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…
