DateTimeFormat formula

[sylvia0218]

I'm having issue with the DateTimeFormat function. 

I'm trying to convert "2024-03-01" from raw data to "03/01/2024". 

I used the DateTimeFormat formula function but it didn't return anything. Can't tell what's going wrong with this formula. 

[ChrisTX · Accepted solution]

DateTimeFormat is: Output to String data type

You selected Date for the data type for your new field.

Guessing you're trying to convert from data type Date to data type String?

Chris

[sylvia0218]

I changed the data type from Date to V-W String and it works now, thank you!

[lukas_olsovsky]

Hi @sylvia0218 , you can also use ReplaceChar(date, "-", "/") and data type "String". It will work the same ;)

Lukas