In the case I'm working on, I need to pull the data from an Excel file. I have a Date column with date data and an unfixed format in the input file. I can only import the data into Alteryx's default format.
Some sample data would be great. The simplest way I know to convert your input column to date output column would be to just use DateTime Tools to parse individual date formats then combine them at the end into one column like this: