Date Format Correction

Question

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/20152018/01/042011/11/02

Thanks in advance

messi007 · Answer

@Adarsh_R3,

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

Regards,

Adarsh_R3 · Answer

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?

suby · Answer

Hello,

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

Attached the Workflow.

DateTimeFormat.yxmd