Extracting Date from Filename

Good day,

Can I ask for you help in extracting the date from a filename? See below filename.

DDB Fest.Daily_01.05.24_Final.xlsx
DDB Sander Daily_01.08.24_Final.xlsx

Results of date should be 2024-01-05 and 2024-01-08.

Thanks and looking forward for your assistance.

Kamen

Date Time

Accepted answers

DateTimeParse(REGEX_Replace([File Name], '.*_(\d{2}\.\d{2}\.\d{2})_.*', '$1'),'%m.%d.%y')

Use this formula

DateTimeParse((regex_replace([Field1], '.*_(\d{2}\.\d{2}\.\d{2}).*', '$1')), "%m.%d.%y")

delevering the required results

See attached workflow

Would you know why I am getting a null result?

Hoping for your response. Thanks,

Kamen

DateTimeParse(REGEX_Replace([File Name], '.*_(\d{2}\.\d{2}\.\d{2})_.*', '$1'),'%m.%d.%y')

Use this formula

DateTimeParse((regex_replace([Field1], '.*_(\d{2}\.\d{2}\.\d{2}).*', '$1')), "%m.%d.%y")

delevering the required results