Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

DateTimeParse

erinrog
5 - Atom

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. 

2 REPLIES 2
AndrewDMerrill
13 - Pulsar

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.

erinrog
5 - Atom

Thank you, I think you're right!

Labels