Extract Date and Sort

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

Workflow

Date Time

Accepted answers

@KamenRider One way of doing this

@KamenRider One way of doing this

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 .

Thanks guys

Kamen