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.
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.
Thank you, I think you're right!