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.

6 comments

Veronique Palmer says:

July 21, 2020 at 8:45 am

On the standard vs friendly format? I’m not sure no. The regional settings changes the whole site though.

LikeLike
kiwithatflew says:

July 20, 2020 at 6:53 pm

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

LikeLike
Veronique Palmer says:

April 15, 2020 at 2:30 pm

I feel you Zhi. 🙂

LikeLike
Zhi Wei Tham says:

April 15, 2020 at 2:20 pm

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.

LikeLike
Veronique Palmer says:

April 25, 2019 at 11:19 am

I agree, it drove me crazy too.

LikeLike
shewrite63 says:

April 25, 2019 at 11:16 am

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.

LikeLike