Date formatting

[learnalteryx]

Hi Team, 

I have a date column which has dates in these two format, could you please tell me how I can make it to yyyy-MM-dd format, see below example ?

[Qiu · Accepted solution]

@learnalteryx 
We can seperate the data stream for the two format as it contains "-" or not.

For #1 and #2 use Date Time Tool to convert it to DateTime format then Date format

For #3 and #4, it is already in DateTime format just change it to Date with a select tool.

At last Union them back together.