Date Format Correction

[Adarsh_R3]

Hi,

I've got a field in the data set where the dates are formatted incorrectly i.e. the same field contains the format dd/MM/yyyy and yyyy/MM/dd.

21/04/2020

01/11/2015

2018/01/04

2011/11/02

Thanks in advance

[messi007]

@Adarsh_R3,

Alteryx default date format is yyyy-MM-dd however if you want to change it you can use datetimeformat.

Please see below 

Attached the workflow,

Hope the helps!

Regards,

[suby]

Hello,

On you workflow Click on the Add/Remove tools to add the Parse tool and use the Date time tool.

Attached the Workflow.

[Adarsh_R3]

Hi messi007,

thanks for your suggestion... but I'm getting the following error.

Does this mean that we have even more date format in the same field?

[messi007]

@Adarsh_R3,

Yes, you can do a group by in the column Accounting Date and it will give you the different format.

Regards,