How to change Date Format of Sharepoint List?

Hello

Currently Sharepoint List Displaying the date format as : 29/04/2008 i.e. DD/MM/YYYY

Can i change it to 29-Apr-2008.

I want to take first three Characters of the month.

If not so then 29-April-2008 format will work too.

Regards

Awdhesh

 

  • Moved by Mike Walsh FIN Tuesday, May 25, 2010 2:37 PM admin q (or if not possible via admin then customization) (From:SharePoint - Enterprise Content Management (pre-SharePoint 2010))
May 25th, 2010 12:00pm

The date format is dictated by Locale. This is effected by what locale the site is created is. It can be changed on an individual basis by clicking on the User ID drop down in the top right -> MySettings -> My Regional Settings -> Change the Locale.
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2010 2:11pm

hi,

even you can change in site/site collection under site actions ----> site settings --------> in site administration ----> regional settings

May 25th, 2010 3:38pm

Hi,

 

You can create calculated column instead.

For example:

1.      you have the date column like “Created”

2.      Create new calculated column, type the formula like “TEXT(Created, "dd-mmm-yyyy")

Now you can use this column displayed in your view.

For more information, please refer to

http://www.sharepointusecases.com/index.php/2009/01/customizing-datetime-format-on-a-list-view-web-part/

 

Hope this helps

 

Thanks!

Stanfford

  • Marked as answer by Stanfford Liu Friday, June 04, 2010 1:55 AM
Free Windows Admin Tool Kit Click here and download it now
May 28th, 2010 6:11am

Hi want only Time 

like 2.15 PM and 12.00 AM

what is the format?

December 12th, 2012 9:28am

I like this simple fix for this noted challenge. I assume this was logic for SharePoint 2010.  Does anyone have a way do to the same function in SharePoint 2013?
Free Windows Admin Tool Kit Click here and download it now
November 8th, 2013 10:25pm

Thanks for this!
May 12th, 2015 2:16am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics