String to date converse

[Luk88kk]

Hi,

I have a column that has a "string" data type:
The dates are stored in this way:
Tue, 24 Oct 2023 00:00:00 +0200
I would like them to have a data type "date" and look like this:
24/10/2023

I have tried using both Data Tool and DateTimeParse in Formula Tool but without success.
Could someone please help me with this

[binuacs · Accepted solution]

@Luk88kk Alteryx support the ISO format which is YYYY-MM-DD, rest of the date formats should be in the string format

[Luk88kk]

Hi @binuacs

works great, thank you very much for the explanation and for the ready-made solution.

Have a good day.