Extract date ("dd/mm/yyyy") from string

[BautistaC888]

Hello,

I need to get the date with format dd/mm/yyyy from a string.
INPUT:
=T("31/12/2021")

OUTPUT:
31/12/2021

I shared with you an example.

[atcodedog05 · Accepted solution]

Hi @BautistaC888 

Here is how you can do it.

Workflow:

Hope this helps : )

[binu_acs]

@BautistaC888 

REGEX_Replace([Field1], '.+\"(.+)\".+', '$1')

[atcodedog05]

Happy to help : ) @BautistaC888 

Cheers and have a nice day!