Extracting Date from Filename

[KamenRider]

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

[Bren_Spill]

See attached workflow

[KamenRider]

Hi @Bren_Spill 

Would you know why I am getting a null result?

 

Hoping for your response. Thanks,

Kamen

[nagakavyasri]

@KamenRider  Try this:

[binuacs · Accepted solution]

@KamenRider 

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

[Raj · Accepted solution]

Use this formula 

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

delevering the required results