New Function To Convert Date Format to Text Format

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.

11 Comments
usman.zia
Master Anaplanner/Community Boss

Thanks for sharing @CallumW this would be very useful and save line items when converting. 

Miran
Community Manager
 
Status changed to: Your support is needed
daian
Certified Master Anaplanner

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. 

Gwen.pryor
Regular Contributor
 
Status changed to: Under Investigation
wwood
Certified Master Anaplanner

Another vote for this.

Alessio_Pagliano
Certified Master Anaplanner

yes please!

himanshu.badhai
Certified Master Anaplanner

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.

jimfeng5
Certified Master Anaplanner

Upvote +1

mdindiongco
New Contributor

Upvoting this too!

SMaddi
Occasional Contributor

I think its useful in to be able to convert text to date and vice versa. 

helennie
Certified Master Anaplanner

Bump for both this and the reverse function. Using TEXT and DAY/MONTH/YEAR is very tedious, cluttered, and inefficient