Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date formatting

learnalteryx
7 - Meteor

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 ?

 

date.jpg

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@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.

0708-learnalteryx.PNG

Labels
Top Solution Authors