Convert Strings to Dates when rows have Different Formats

[rtdavis]

I'm importing a text file and just noticed when I tried to convert a text column to date that the string values are in different formats.  Any suggestions on how I convert each row to a date?

Here is a sample of the date:

Row ID   Date (string value)       String Format
1             7/1/2019 9:09:28 PM      MM/DD/YYYY HH:MM:SS
2             01-07-2019 17:50:49      DD-MM-YYYY HH:MM:SS

Thank you - Randy

[BenMoss · Accepted solution]

There is a great tool on the Alteryx Gallery called the 'BB Date' tool, which tries to automatically detect the different dates that you may have in a single column and change them as such.

The macro can be found at the below link...

https://gallery.alteryx.com/#!app/BB-Date-Tool/5c0093d08a93370cb83db501

Ben

[rtdavis]

Wow that worked perfectly.  Awesome.  Thanks Ben!!