normalizing dates regex replace?

[pvara]

I have a mixed bag of dates I am trying format. The dates are formatted as follows:

06302020

20200630

My goal would be to use a formula tool to reformat those dates as follows

2020-06-30

2020-06-30

Any suggestions and thank you in advanced.

[fmvizcaino · Accepted solution]

Hi @pvara ,

I would suggest you to use datetimeparse function 2 times and then check which parse functions returned a non null date.

Best,

Fernando Vizcaino 

[pvara]

Thank you that can work. very simple just what i needed without getting too fancy 🙂

[JosephSerpis · Accepted solution]

Hi @pvara I mocked up a workflow let me know what you think?