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

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

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

  1. Kenton's avatar
    Kenton
    January 27, 2013 at 05:05

    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 Reply

Create your own website, free on WordPress.com.Create your own website.
Start free