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.
Thanks for sharing @CallumW this would be very useful and save line items when converting.
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.
Another vote for this.
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.
Upvoting this too!
I think its useful in to be able to convert text to date and vice versa.
Bump for both this and the reverse function. Using TEXT and DAY/MONTH/YEAR is very tedious, cluttered, and inefficient
Adding another bump for this-- would save time and build complexity.
Agree . This would be of great help
Agree, this would be a good addition
+1This is needed in just about any model, and sometimes causes a lot of additional calculations which can be cluttering as well as taxing on performance
+1 for this
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.