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 .
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!
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:
@Pranati_Pradhan_6372 Another method using regex_match function