In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

DateTimeParse

erinrog
7 - Meteor

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
CoG
14 - Magnetar

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
7 - Meteor

Thank you, I think you're right!

Labels
Top Solution Authors