Converting Date to m/d/y format in Date Type

[KamenRider]

Guys,

I am a kind of confuse with this since every time I have a date in string format and I use the parse tool to convert to Date format, it always convert to format YYYY-MM-DD instead of MM/DD/YYYY. And when I convert this YYYY-MM-DD to MM/DD/YYYY using the formula tool, it change back to String format.

Can someone help me how I can convert a Date in string format changing to Date Data Type with format mm/dd/yyyy? For example

2024-10-05 (string data type) convert to 10/5/2024 (date data type)

2025-08-10 (string data type) convert to 08/10/2025 (date data type)

2014-14-15 (string data type) convert to 14/15/2014 (date data type)

2018-01-01 (string data type) convert to 1/1/2014 (date data type)

Please advise.

Kamen

[KamenRider]

Hi @apathetichell

Frankly, since it is not working, maybe it is not installed. Is there a way I could verify if it is installed. My problem is that we don't have rights to install

Please advise.

Kamen

[apathetichell]

check on odbc 64 under drivers. what do you see as an error message if you try to write data with alteryx dates to that column?