Convert string to date with inconsistent format

[cpowers]

I have a field where the string representing the date is inconsistently formated as dates with a month and/or date that is just a single digit does not have the filler zero where needed. If I had the string in the "need format" I know I could use the Parse DateTime tool to format to the "convert to date" desired format. Any suggestions on best way to get from "Have Field" to "Convert to Date" field?

Have Field	Need format	To convert to date
10-9-17	10-09-17	2017-10-09
1-12-17	01-12-17	2017-01-12
2-3-17	02-03-17	2017-02-03

Thanks!

[jasperlch · Accepted solution]

The DateTime tool should be able to convert your "Have Field" to "Convert to Date" field without any issues. See workflow attached.

[cpowers]

@jasperlch. I can't open the file, it was created on a newer version then I have.

Updated - converted the file using post Ben added and was able to open. The DateTime tool did the trick by itself. I over thought the formatting and thought I had to use custom (which is not the case) and that was not giving me the desired end result.

Thanks for your help!

[BenMoss]

Here's a blog on how to convert the workflow, it's a useful skill to learn @cpowers

https://www.theinformationlab.co.uk/2018/07/12/downgrading-alteryx-workflows/

[cpowers]

Thank you @BenMoss - I did convert the workflow - learned something else new.