Splitting Date Range Into Two Columns

[anniegullo]

Hey community, I'm still pretty new to Alteryx and I'm having some trouble. I have a column of date ranges that are formatted like this and I'm trying to separate them into two columns. A "Start Date" and an "End Date" column.

I used "Text To Column" and split the dates and removed white space. I was able to convert it to a string but need it to be a date string. As you can see by the image below it's not sorting the correctly because 2019 and 2020 are not sorting correctly. 

[Jonathan-Sherman · Accepted solution]

Hi @anniegullo,

You could use a multi-field formula tool with DateTimeParse(ToString([_CurrentField_]), '%M/%d/%Y') to parse the dates from their current format into a Date format (which you can subsequently successfully sort on)

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[JosephSerpis]

Hi @anniegullo you need to datetime parse your dates into the format Alteryx recognises as a date YYYY-MM-DD then it sort correctly. 

[christine_assaad]

Hi @anniegullo 

You can use Datetime from "Parse" and configure it similar to the attached.

[anniegullo]

Super helpful. Thank you!