Change the #SharePoint Date Format

There are 2 date formats available, standard and friendly.

Here’s what friendly looks like.

Here’s what standard looks like.

If you want to change them, go to the list / library settings.

Then scroll down to the columns and click on any date column.

And change the setting to the one you prefer.

Don’t forget to change the locale in Regional Settings on the site or all your dates will be in the American format.

If you are using dates in the names of your documents, don’t forget that the only date standard that will work, is YYYY-MM-DD.


  1. Hi! Do you know if there is a way to change this on a site-wide basis? So it does not need to be done for every list/library.
    Thank you


  2. Thank you very much for this post.
    When i changed the date from friendly to standard, it drove me crazy when the time zone/region was not correct.


  3. Good one. One annoyance I find with the friendly date format is “modified x hours / x days ago”, etc. until enough time has passed for the actual date to display.


Leave a Reply

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

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

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.