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

About these ads
Categories: Work Tags: , , , ,
  1. Kenton
    January 27, 2013 at 05:05 | #1
    Reply | Quote

    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

Fill in your details below or click an icon to log in:

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

Follow

Get every new post delivered to your Inbox.

Join 236 other followers

%d bloggers like this: