community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Convert Dates Without Knowing Format in the Input

Atom

I'm encountering a situation where an excel spreadsheet will have a date column that may be formatted in a variety of ways. For example, the column may have dates formatted like this, depending on who fills out the spreadsheet:

 

mm/dd/yyyy

mm-dd-yyyy

mm/dd/yy

yyyy-mm-dd

 

etc.

 

It seems that the DateTime conversion tool is only useful if you already know the format ahead of time. Otherwise, I would have to build a workflow that would include a DateTime conversion tool for every conceivable date time format. Is there a combination of other tools that might be able to accomplish this?

Quasar

If you know that the column only includes date strings, you could use the Formula Tool with the regex functions to parse out to a standard format.

Quasar

For example see attached. Will probably need some tweaking to get all the likely formats but should give an idea.

 

2018-04-20_14-05-29.png

Labels