Convert multiple Date formats from String to Date data type

Adarsh_R3

Hi all,

I have a field that contains dates but the data type is in string format. The issue is that this field is not uniform since it contains multiple date formats. 

For example:

Date Field

13-05-2021

21 March 2020

18012020

20200726

Is there any way to process this field and convert it all to yyyy-MM-dd, please note that the field contains multiple formats I've just given a sample of how the values look like in this field. 

Thanks a lot for your time.

atcodedog05

Hi @Adarsh_R3 

You would need to check for each dateformat and parse them accordingly if there are any new formats you would need to add them.

Workflow:

Hope this helps : )

dates.yxmd