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

Alteryx designer Discussions

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

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

Learn More

summarize format of dates in a column

Asteroid

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

Labels