Date in Alteryx

Question

Hello All!

I'm trying to create a macro where I feed in date as input and I get the day as output. Attaching my workflow. I'm not sure and want to check if alteryx can convert any date format to the specific mm/dd/yyyy format ? Do i need to make sure that the excel column is specified as date or can it be general ? Would alteryx be able to convert any format for e.g. date inputted as 12.10.2014 or 10.12.2014 or 10/12/2014 as mm/dd/yyyy and give me the date against it ?

Thanks!

Madhur

Day of the week macro.yxmc

Date.xlsx

Madhur12 · Answer

Thanks @binu_acs ! Getting this error:

binu_acs · Answer

@Madhur12 try the attached workflow

Day of the week macro.yxmc

Madhur12 · Answer

Thanks @cjaneczko! But I'm not able to make this work in a dataset that has date formats mm/dd/yyyy and mm.dd.yyyy. Attaching my workflow. Can you help ?

Day of the week.yxmc