Text date to date format

[carterfleming]

How do you convert "Oct 03, 2023" to "10/03/2023"?

[DataNath · Accepted solution]

Hey @carterfleming, I'd personally use the following expression in a Formula tool - just replace [Date] with your own field name of course:

DateTimeFormat(DateTimeParse([Date],'%b %d, %Y'),'%m/%d/%Y')

[carterfleming]

Perfect, thank you!