Trouble with formatting a date field

[WesDavies]

Hello,

I am trying to format a field that is coming in as a date field. The data looks like 

2025-02-21 00:00:00

I have tried several variations of formatting formulas, and they all result in a null result. I am able to use the datetime parse tool to convert it to text, but can't get it to give me just the mm-dd-yyyy in a formula tool.

Thanks in advance!

[alexnajm · Accepted solution]

DateTimeFormat([date field], "%m-%d-%Y") should do it if your original data is truly in a DateTime format!

The result though will be a string, so make sure you are creating a new column accordingly