DateTimeParse

Question

I'm trying to convert a column with a V_String data type into a date format. I have tried to use the DateTimeParse function, however, keep receiving error after trying to run. I think I might be receiving these errors because the single digit months don't have a zero in front of them as seen in the first screenshot below. In the second screenshot I show what I attempted to input in the DateTimeParse function and the third shows the error I'm receiving. Please let me know if you have any suggestions to go about this.

Alteryx Screenshot.png

Alteryx Screenshot #2.png

Alteryx Error.png

erinrog · Answer

Thank you, I think you're right!

CoG · Answer

It looks like you just got a warning. The DateTime Parse tool is definitely smart enough to work with single digit months. The error seems to indicate only a single record failed likely due to a stray "-" instead of an actual date.