Converting Different Format Dates in a single Column to "dd-mm-YYYY" format

Question

Hi All,

I wish to convert different format of dates and strings in one column to "dd-mm-YYYY" string format . Is there a way we can handle this in Alteryx Designer? E.g. shown below as well as uploaded

DateReq Format4/6/201506-04-201511/9/201509-11-20151/2/201601-02-201628/03/201628-03-201631-07-201731-07-2017

Dates.xlsx

Emmanuel_G · Answer

Hi @Tej_Singh ,

One way to do this with formula tool

Date Parsing.yxmd

grazitti_sapna · Answer

@Tej_Singh, here is an another way of solving this.

Formula: if REGEX_Match(Date,"\d+/\d+/\d+") then DateTimeFormat(DateTimeParse(Date,"%d/%m/%Y")
,"%d-%m-%Y")
elseif REGEX_Match(Date,"\d+-\d+-\d+")
then [Date]
else Null() endif

I hope this helps!

Thanks!

IraWatt · Answer

Hey @Tej_Singh,

The simplest way to do this without formulas is to use the DateTime tool like this:

Essentially the first tool converts your text dates to a date data type and then the second tool reformats that date to your desired output.

Any questions or issues please ask :)
HTH!
Ira

Workflow.yxmd