Naming files by date for sorting

Naming files by date

Are you trying to organize and sort documents with dates in the title? For example, say you want to always have a list of newsletter files or meeting notes sort in chronological order. You may have started out naming files like this:

Newsletter-June-2018.pdf
Newsletter-July-2018.pdf
Newsletter-August-2018.pdf

But when you try to sort the file names, they are out of order like this, which is alphabetical and never chronological:

Newsletter-August-2018.pdf
Newsletter-July-2018.pdf
Newsletter-June-2018.pdf

What’s a better way to do this so that they actually sort in chronological order? Always use YY-MM-DD or YYYY-MM-DD format when naming files for this purpose. This means your documents will sort by year, then month, then day. And you can leave off DD (the day) if you don’t need to be that granular. Here’s our earlier example:

Newsletter-2018-06.pdf
Newsletter-2018-07.pdf
Newsletter-2018-08.pdf

And remember that if you want to sort documents by date that have different names, you can put the date first rather than second. Here’s another example, which shows how this will sort different types of files chronologically:

2018-06-Interview-Notes.docx
2018-06-Newsletter.pdf
2018-06-Newsletter-Banner.jpg
2018-07-Interview-Notes.docx
2018-07-Newsletter.pdf
2018-07-Newsletter-Banner.jpg
2018-08-Lead-Article.docx
2018-08-Newsletter.pdf
2018-08-Newsletter-Banner.jpg

In this particular example, this means that any files used to create the newsletter are grouped together by date as well.

Naming files consistently and help your folders and archives stay organized for years to come!


Recent Posts / View All Posts

Is Internet Explorer a modern web browser?

Moving away from Internet Explorer

| Security | No Comments
Is Internet Explorer a “modern web browser”? Is it a web browser at all? Should you be using it? Due to a recent blog post from Microsoft on “the perils...

Why do you still need anti-spam and anti-virus protection?

| Security | No Comments
It’s 2019. Do you really need to pay for anti-spam and anti-virus software for your company? Is there still a pressing need for these? And can you make do with...
Office 365 Tip - Sharing links

Office 365 Tip: Sharing links instead of sending copies

| Office 365, Tech Tip | No Comments
Ready to send off a file attachment to your colleagues for their review and feedback? Wait a second, because there’s a better way in Office 365 to more easily and...