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

Advertisement
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 Reply

Please log in using one of these methods to post your comment:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

%d bloggers like this: