Extracting Date

[KamenRider]

Hi,

Can I ask for your assistance in extracting the date. Below is my example.

BACKLN Driving (12.08.2021).xlsx --- results should be 2021-12-08

CACLN Driving (10.31.2023).xlsx --- results should be 2023-10-31

I have this formula but it give me a null results.  -- DateTimeParse(REGEX_Replace([FileName], '.*?_(.*?)_.*', ''),'%Y%m%d')

Hope you could help me on this.  Thanks,

Kamen

[CoG · Accepted solution]

DateTimeParse(REGEX_Replace([Field1], ".*?(\d{2}[.]\d{2}[.]\d{4}).*", "$1"),"%m.%d.%y")

[binuacs · Accepted solution]

@KamenRider