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
20 - Arcturus

@Pranati_Pradhan_6372 Another method using regex_match function

image.png

Labels