Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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