Splitting Date Range Into Two Columns

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.

incorrect date sort.png

Date Range Split.yxmd

Workflow

Date Time

Accepted answers

Jonathan-Sherman

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

20200730 - ConvertDates.yxmd

All comments

Jonathan-Sherman

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

20200730 - ConvertDates.yxmd

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

Date Range Split.yxmd

Christine_Assaad

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

Super helpful. Thank you!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703