Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

summarize format of dates in a column


Hi Team,


I have different sources for date column and all of them are put in one column.

The dates are entered manually, but in correct date format. 

ex: 2019-01-01 or 01-Jan-2019 or 2019/01/01


The problem is i am not sure how many such formats are being used in the date column.

Since it is not in alteryx date format i cant directly use "select" tool to convert to date.


is there any option to show the format of date in a cell?

in that way i can summarize the format of dates and do the datetimeparse accordingly.


Please help, thanks in advance