Why Using the Date Format YYYY-MM-DD Works #SharePoint

Files are stored in alphabetical and numerical order from the left hand side in Microsoft products.  Look at the order of the files and documents in this example.  If you had to find the newest minutes, you would have to read through the whole list to find them.

Date-format-in-fileshare-unformatted

Date-format-in-SharePoint-unformatted

But if you changed the date format to YYYY-MM-DD, it would be instantly obvious.

Date-format-in-SharePoint-formattedAnd then in SharePoint you would be able to either change the filter to show newest to oldest.

Date-format-in-SharePoint-filteredOr alternatively, change the view to sort the name in descending order.

Date-format-in-SharePoint-sort

And then newest docs would always be on top. 🙂

Date-format-in-SharePoint-sort-newest-first

About Veronique Palmer

Empowering people one at a time.
This entry was posted in SharePoint 2007, SharePoint 2010, SharePoint 2013, Tutorial. Bookmark the permalink.

7 Responses to Why Using the Date Format YYYY-MM-DD Works #SharePoint

  1. Pingback: SharePoint is NOT Your Fileshare - The Microsoft SharePoint Blog

  2. Pingback: SharePoint is NOT Your Fileshare | Views from Veronique

  3. Pingback: Why Using the Date Format YYYY-MM-DD Works #SharePoint - The Microsoft SharePoint Blog

  4. Hi Ken, thanks for the great tips. 🙂 Isn’t it crazy that we’ve got so many date formats on this planet. 😉

    Like

  5. Pingback: Why Using the Date Format YYYY-MM-DD Works #SharePoint - SharePoint User Group Blogs - Bamboo Nation

  6. kenburrell says:

    Hi Veronique,
    Quite agree – this is a trick that I have been finding useful for years. It works in standard folder trees as well as SharePoint, and is particularly useful where you have lots of files with essentially the same name relating to different dates, e.g. meeting agendas or minutes, monthly / weekly reports, staff appraisals, etc.
    Another useful trick for any “live” file that is updated frequently and doesn’t require a version history (e.g. Risks & Issues Logs) is to prefix the filename with a non-alphanumeric character (I use a tilde “~”) as this will bring it to the top of any alphanumeric listing.
    Also, consider using the date format ddmmmyy or even ddmmmyyyy if there is the slightest chance that your documents will be used in both the USA and the UK, as it wastes time and is a potential source of error if people don’t know whether 07/01/13 means the 7th of January or the first of July. 07Jan2013 is utterly unambiguous and in its shortened form ddmmmyy is also more efficient on characters and visual space than dd/mm/yy or mm/dd/yy.
    I enjoy your blog, keep up the good work!
    Regards, Ken

    Like

  7. Pingback: SharePoint Date Format for South Africa and Other Regions Outside the USA | Views from Veronique

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s