Unable to Convert Single Digit Month In Date 1312019 To Alteryx Date Format

[ronone10]

I'm using the Date Time Tool to convert 1312019 to 2019-01-31 and I get the following error:

ConvError: DateTime (19): DateTime_Out: Cannot convert "1312020" to a date/time with format "%m%d%Y": Month number is out of range 1..12: '1312020' Record #1

In the DateTime setup, I selected Custom and used: MMddyyyy.  Can someone help me convert 1312019 to Alteryx's date format?

Thanks

[JosephSerpis · Accepted solution]

Hi @ronone10 I mocked up a workflow let me know what you think?

[ronone10]

Hi Joseph (Joe),

Works flawlessly!!!  Thank you for the quick response. You also anticipated that the solution should address the eight digit date format. I didn't have to come back with a follow-up question. I'm a bit surprised that these extra steps are necessary to address a seven digit date and the Date Time Tool doesn't somehow include a solution.

Thanks Again,

Be Safe,  Ron