Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

I have a data like 1971-12-12 , 10/31/1993 and 11/29/2002 .

Pranati_Pradhan_6372
6 - Meteoroid

Now how to get  the correct format  1971-12-12 = 1971-12-12

                                                         10/31/1993 = 10-31-1993

                                               and     11/29/2002 = 11-29-2002  in Alteryx .

4 REPLIES 4
caltang
17 - Castor
17 - Castor

Two ways you can do so:

image.png

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
caltang
17 - Castor
17 - Castor

The usual pattern if you are using a Multi-field Tool:

DateTimeParse(ToString([_CurrentField_]),"%m/%d/%Y")

 

Whereas if you use a DateTime tool:

%m/%d/%Y

 

Hope this helps! 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
caltang
17 - Castor
17 - Castor

Ah sorry @Pranati_Pradhan_6372 I just read your title again.

 

If you have multiple types of dates in your data, you can use a simple Filter tool to achieve a separation of data so that you can apply different techniques on them like so:

image.png

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
binuacs
21 - Polaris

@Pranati_Pradhan_6372 Another method using regex_match function

image.png

Labels
Top Solution Authors