Home > Work > Calculated Column Formula: Date Format #SP2010 #SharePoint #in

Calculated Column Formula: Date Format #SP2010 #SharePoint #in

March 9, 2011 Leave a comment Go to comments

Just a reminder for me really… At a client at the moment who wants to put the date in list web parts in the following format: dd-MMM-yyyy.

I found the following article suggesting using the TEXT function in a Calculated Column

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

Formula Example:

1 =TEXT(Created,"dd-mmm-yyyy")

Output:

09-Mar-2011

Categories: Work Tags: , , , ,
  1. Kenton
    January 27, 2013 at 05:05
    Reply

    Hi, thanks for posting this! Any idea why–when an event is an “All Day Event”, this seems to display the wrong day (it displays the day before)?

  1. No trackbacks yet.

Leave a comment