Formula field to change the way the date is written

How can I use the formula field to change the way a date is written from for example from May 5, 2022, to ‘5th day of May, 2022’.?

Hi AFrazier,

Thanks for reaching out! You can use the PARSEDATE formula to create a second format for the same date as follows:


Let me know if you have any follow-up questions!
Eszter