community
cancel
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?

LEARN MORE
SOLVED

Convert Strings to Dates when rows have Different Formats

Highlighted
Atom

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

 

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

 

Ben

Atom

Wow that worked perfectly.  Awesome.  Thanks Ben!!

Labels