Sorting Data by Date

[Cosullivan97]

Hey, when I try to order the datein Alteryx, it orders according to the first digit. So instead of being 1/3/2020, then 2/3/2020 and so on it jumps to 10/3/2020. Is there some way of converting this into date format that would have "01" instead of "1" to solve my issue? Or any other suggestions welcome.

Thank you,
Claire

[JosephSerpis · Accepted solution]

Hi @Cosullivan97 if you use datetime parse you can convert the date into a format that alteryx can recognise as a date and it will sort correctly.  I have mocked workflow that will show how to do this a couple of ways.