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.
Solved! Go to Solution.
Here is how you can do it.
Formula:
REGEX_Replace([Field1], "0?(\d+)/0?(\d+)/(\d+)", "$1/$2/$3")
Workflow:
Hope this helps : )