Mixed date format conversion

[JanaZ]

Hi there

I have a set of mixed date formats, how can I transform it to dd/mm/yyyy?

from here

Date

12.11.98

2000-08-21

23/07/2013

TBA

to here

Date

12/11/1998

21/08/2000

23/07/2013

[flying008 · Accepted solution]

Hi, @JanaZ 

Look that:

IF Contains([Date], '.') THEN DateTimeFormat(DateTimeParse([Date],'%d.%m.%y'),'%m/%d/%Y')
ELSEIF Contains([Date], '-') THEN DateTimeFormat(DateTimeParse([Date],'%Y-%m-%d'),'%d/%m/%Y')
ELSEIF Contains([Date], '/') THEN DateTimeFormat(DateTimeParse([Date],'%d/%m/%Y'),'%d/%m/%Y') 
ELSE Null() ENDIF

******

If it can help you , please mark it as a solution and give a like for more share.

[JanaZ]

@flying008 

It's perfect, thank you so much for the solution. 

I am struggling with the date/time format in Alteryx.

Cheers, 

Jana