CONVERTING STRING (MULTIPLE FORMAT) TO DATE

[dunkindonut7777]

Hi how to convert these dates into standard format using only formula tool:

Origin Date	Expected Output
2021-01-14	2021-01-14
02/13/21	2021-02-13

Can you help me with this one pls?

[WilliamCTX]

There are few ways to achieve the desired output.

Not sure what is the reason to restrict the workflow to apply only the formula tool.

Nevertheless, here is my solution.

Hope this helps.

[binuacs]

@dunkindonut7777 One way of doing this