Please help convert date

[htalteryx]

Can you please use a formula tool to convert the text string to a date?  You will know the problem is solved by using Excel to filter the Output column and see:

2023

      January

             1

instead of:

1/1/23

Input (text)	Output (should be date, not string)
1/1/2023 12:00:00 AM	1/1/23

Thank you!

[Felipe_Ribeir0]

Hi @htalteryx 

One way of doing this

datetimeparse([Input], '%d/%m/%Y')

[dYoast]

@htalteryx ,

If you are expecting to see the date as 2023-01-01 in Excel, you would need to change the regional format data of your computer or format the cell to display as expected.

Excel appears to format a cell with a date as a Short date - 1/1/2023.

You can change it in Alteryx as @Felipe_Ribeir0  suggested, but it will not display the same in Excel.