How to sort by date in filename?

Question

I have a bunch of meeting minutes, where the filename is the date the meeting took place. I would like to sort by this date.

The dates in my case are of the following form: 01.01.2009.doc 30.12.1999.doc 6.05.2010.doc ..

Some files are also of the following form: AD 01.01.2009.doc KT2 05.05.2000.doc ...

How can I do this? Is it even possible?

Answer 1

rename your files YYYY-MM-DD.doc and you're fine.

Answer 2

Use something like Bulk Rename Utility to rename the files into the format *yymmdd_anyothertext.doc*, then sorting on name will arrange the files in date order.

BRU support regular expression, or if necessary you can just do the renaming in several passes if the regex isn't too obvious.

Answer 3

If the files were created on set dates you can just sort them by date in explorer. I'm guessing this is not the case. So if you rename files as Molly suggested (yyyy-mm-dd) then sorting by name will also sort them by date.

Since you already have a bunch of such files instead of renaming them one by one, I suggest you use Total commander, which has built in multi-rename tool. This tool enables you to easily rename files to this format. Just rename each batch of files that have same type of name after another.

To rename for example files named dd-mm-yyyy to yyyy-mm-dd:

• select files you want to rename (using either r-mouse click or space)
• press ctrl+M or select menu Files -> Multi rename tool
• press Range button and select year part, press ok
• repeat for month and day and put - in between, you should end up with [N7-10]-[N4-5]-[N1-2]
• press Start button (bottom of the form) to run the renaming process
• repeat the process for other groups with similar names