Remove Leading Zeroes in days and months

[BautistaC888]

Hello:

I need to remove the leading zeroes from my dates.
For example (the dates are dd/mm/yyyy in string format):

And i need:
2/1/2020 First line.

Thank you.

[atcodedog05 · Accepted solution]

Hi @BautistaC888 

Here is how you can do it.

Formula:

REGEX_Replace([Field1], "0?(\d+)/0?(\d+)/(\d+)", "$1/$2/$3")

Workflow:

Hope this helps : )