Please help convert date

Question

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 AM1/1/23

Thank you!

dYoast · Answer

@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.

Felipe_Ribeir0 · Answer

Hi @htalteryx

One way of doing this

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

date.yxmd