We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Sorting Data by Date

Cosullivan97
5 - Atom

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

 

 

Cosullivan97_0-1596021020688.png

 

1 REPLY 1
JosephSerpis
17 - Castor
17 - Castor

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.

Labels
Top Solution Authors