Change SharePoint default date time format to dd MMM yyyy

Question

How do we change SharePoint default date time format to dd MMM yyyy( e.g., 1 May 2013),

We can change regional setting to change date format but i can not find anything which display month as word.

I am referring following article it seems working except dd MMM yyyy format ( e.g., 1 May 2013). I've notice issue with displaying month in word, other format seem working.

http://sharepointex.blogspot.in/2007/09/how-to-modify-date-format-in-sharepoint.html

Any idea why it month name is not displaying as expected?

Regards,

score 6 · Answer 1 · answered Nov 03 '13 at 15:48

6

For Sharepoing 2010 Regional Settings are hidden for the Central Admin site collection. However, you can get to them by typing the url (substitute mysharepointserver:port for your central admin web application).

http://mysharepointserver:port/_layouts/regionalsetng.aspx

answered Nov 03 '13 at 15:48

Saariko

1,703
4
26
46

Changed the locale in the link above and all the sites in my web application. Worked for me.. Am I missing anything??? – Muhammedh Jan 14 '14 at 05:09
1

Works for SharePoint 2013 as well – Shailen Sukul Nov 24 '14 at 23:55

score 2 · Answer 2 · answered May 23 '13 at 05:46

I understand that you want to change the format of date& time columns for a SharePoint Site .Here are two options :

1.You can modify the view of the view in SharePoint Designer to format the date &time column . Change the formula to ddwrt:FormatDate(string($thisNode/@*[name()=current()/@Name]),1033,7) .

2.You can Modify the Regional Settings for the site collection .Change the Locale to other countries ,the date format will change automatically for all the existing data &time columns .

I have tried with German and its date &time format is like dd mm yyyy .

Thanks for your response 1. Solution works if we have few place to change but not for everywhere for example, created and modified date on each add/edit list\library forms 2. we can regional settings but not to specific format dd MMM yyyy I want to change date time format everywhere in sharePoint. — Nikhil Patel, May 23 '13 at 08:05

score 1 · Answer 3 · answered Feb 03 '16 at 04:24

1

Just change the Locale from Site's Regional Settings within Site Administration > Regional settings.

I have tried with SharePoint 2013

Thanks, Chiranthaka

answered Feb 03 '16 at 04:24

ChiranSJ

195
1
3
20

score 0 · Answer 4 · answered Dec 26 '13 at 09:59

I understand you need a global site setting; however if you opt for the field by field format, you can format to a specific format by specifying "dd MMM yyyy" explicitly in your XSL.

<xsl:value-of select="ddwrt:FormatDateTime(string($thisNode/@*[name()=current()/@Name]) ,1033 ,'dd MMM yyyy')"/>

http://afsawaf.blogspot.com/2013/12/sharepoint-2010-format-view-date-format.html

Good luck!

Change SharePoint default date time format to dd MMM yyyy

4 Answers4