Formula for converting dates

[calvincarr29]

I have a column that's showing dates as: 

2022-05-31 but I want it to show 05-31-2022 - What formula would I use? 

[binuacs · Accepted solution]

@calvincarr29 

DateTimeFormat([Date],"%m-%d-%Y") - Change the data type to string

[calvincarr29]

@binuacs You're the man! Thank you for coming in clutch today.