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!
Solved! Go to Solution.
@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!
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/
Thank you @BenMoss - I did convert the workflow - learned something else new.