Extract Date and Sort

[KamenRider]

Hi,

Kindly extract the date in this filename, and sort from latest. Please convert date format to May, 14, 2024 (sample)

05.11.24 Dorres Seekend Poliday Puck Exp Date Report.xlsx

05.12.24 Dorres Seekend Poliday Puck Exp Date Report.xlsx

05.13.24 Dorres Seekend Poliday Puck Exp Date Report.xlsx

Thanks,

Kamen

[binuacs · Accepted solution]

@KamenRider One way of doing this

[AGilbert]

Here are two regex expressions to extract the date from the file name and the datetime conversion expressions.

The datetime specifiers (%B, %d, %y) are explained in the help documentation here .

[KamenRider]

Thanks guys

Kamen