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.
Solved! Go to 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
Thank you that can work. very simple just what i needed without getting too fancy 🙂