By default, the date format in SharePoint is set to the US format (MM/DD/YYYY).
I will break down the steps to change SharePoints date format in this article.
SelectSite information > View all site tweaks.
UnderSite administration,clickRegional parameters.
Click theLocale drop-down icon,opt for desired region, and click theOKbutton.
And from there, you might change the date format according to your required region.
So, go to the list where you want to modify the date style according to your preferred region.
So, you must key in in your column name in that place.
I have given the date format in dd-mmm-yy.
But you could put your date format according to your region format.
For example, you’re able to give dd/mm/yyyy, or mm/dd/yyyy, etc.
There are so many date formats that you’re able to change for the list column.
Now, click theSingle line of textoption.
After that, hit theOKbutton.
Now, go back to your list and see the modified date format in the newly added column.
Go to theColumnssection and hit theModifiedcolumn currently in the friendly format.
Under the Display format section, click theradio buttonforStandard.
So, what is the Friendly format for the date & time?
But the friendly format differs because you wont see any date here.
Instead, you will see yesterday, two days ago, etc.
This friendly format is mainly used on social media platforms.
Now, lets see how to change the SharePoint list or library date format to standard format from friendly.
For List
For Document Library
FAQs
What is SharePoints default date format?
By default, SharePoints date format is in English (United States) and formatted as MM/DD/YYYY.
What is the friendly format in SharePoint?
Friendly date format is used mainly in social media platforms.
When do you should probably change the SharePoint date format?
You must change the SharePoint date format before creating the SharePoint site.
Otherwise, you have to adjust the date format for every subsite manually.
By default, the SharePoint date format is set to English (United States).
So, changing the date format becomes obsolete if youre in another region.
From this article, you already know how to change the date format for your SharePoint site.
However, if you need more help regarding SharePoint, yo knock me in the comment box below.
Good luck with SharePoint!
