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
Solved! Go to 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
Wow that worked perfectly. Awesome. Thanks Ben!!