New Function To Convert Date Format to Text Format
It would be very useful to have this functionality rather than convert to numbers through DAY, MONTH, YEAR and back to text through TEXT function.
Best practice would dictate to split these functions out but this increases clutter and causes unnecessary calculations in models.
Comments
-
0
-
This would be a great enhancement! Although you can currently convert using the Day/Month/Year with Text formulas, it would simplify things if there was a formula that directly converted dates to text.
1 -
0
-
Another vote for this.
0 -
yes please!
0 -
The opposite is also highly usable. Most often the data comes as text from files. Need to be able to convert that text to a date using DATE function without having to individually extract Year, Month, Day from the text and then converting it to date format.
2 -
Upvote +1
0 -
Upvoting this too!
0 -
I think its useful in to be able to convert text to date and vice versa.
1 -
Bump for both this and the reverse function. Using TEXT and DAY/MONTH/YEAR is very tedious, cluttered, and inefficient
1 -
Adding another bump for this-- would save time and build complexity.
0 -
Agree . This would be of great help
0 -
Agree, this would be a good addition
0 -
+1
This is needed in just about any model, and sometimes causes a lot of additional calculations which can be cluttering as well as taxing on performance0 -
+1
0 -
+1 for this
0 -
+Vote
0 -
+1
0 -
+1
Feels like it should absolutely be native functionality
0 -
Upvoting the same!!
0 -
+1!!!!
0 -
+1
Agreed, I think it's helpful for converting the text to date and vice versa.
0 -
+1
0 -
This would be a very useful feature
0 -
Upvoting for the Same!
0 -
+1
0 -
An update would be appreciated @Anaplan!
0 -
Where is the link to refer?
0
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!