Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.

Convert Strings to Dates when rows have Different Formats


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

Alteryx Certified Partner
Alteryx Certified Partner

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...!app/BB-Date-Tool/5c0093d08a93370cb83db501




Wow that worked perfectly.  Awesome.  Thanks Ben!!