This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
So I read and read and still couldn't find anything that would use most all of the supported date formats and auto detect which to use and then convert that to a date. I found one article that did it for 4 date formats, but I wanted it to be able to handle 50+... I think there were some python libraries that would do it, but I needed it to be native Alteryx. So... I took a stab at it. It might not be the most elegant, but the attached macro will automatically detect most any date format and convert it to a standard YYYY-MM-DD date. Now, of course, it has to choose dd vs mm first... so I defaulted to mm/dd/yyyy over dd/mm/yyyy as long as it was an eligible date (US preference). I guess that could have been a parameter into the macro. Feel free to improve and post back here!
Here is an updated version with a few tweaks. This is version 10.5, but I don't have a way to get it to 10.1. Sounds like Alteryx has something in the works that converts dates automatically coming to the online gallery.