Posted: October 13th, 2009    By: Devin Walker   

SharePoint Calendar IconThe ITS department created a new calendar dashboard and were delighted that they could finally discontinue the Outlook Public Folder Calendars that were previously in use. There was though one request that is completely understandable: “Please remove the ’12:00 AM and 11:59 PM’ values for the Start Time and End Time and instead just make it one column.” I will show you how I satified this request.

To explain the situation further here are some images to display the request:

LAN On-Call Schedule

To the left you see the Summary View of the calendar in a Web Part Zone on the Calendar dashboard. The Start Time and End Time both display the time in addition to the date. This is the default setting of the Events MOSS content type.

We do not want to alter the default content type because all other calendars that use it will be affected. The events to the left are all day events, therefore the times are not necessary. To show the correct single “Date” Column we will first need to create a Calculated column.

  1. Enter your Calendar list and click Settings > List SettingsEnter your Calendar list and click Settings > List Settings
  2. Beneath the Columns section click Create Column
    Beneath the Columns section click Create Column
  3. Give the Column an appropriate name; for this example we will name it “Date.” Also, select the Calculated Column option button.
    Provide the Column an appropriate name
  4. The formula we will use for this example displays the “End Time” column as text without the day time. This is achieved by specifying the specific text fields that will be displayed in the forumla below.
    Type your formula in the box
  5. Return to the page where your Calendar Summary View webpart is displayed and modify the webpart…
    SharePoint Calendars Step 5a
    and Edit the Current View.
    Return to the Calendar Summary View
  6. Uncheck the Start Time and End Time columns, Check the calculated column we just created (our example is named “Date”), and position it to your liking. Confirm the changes by clicking OkUncheck the Start Time and End Time columns.
  7. Confirm the rest of your modifications and check in and publish the page. Please note this forumula will not work for reoccuring events.

Related posts:

  1. How to Move SharePoint Calendars Fast Moving a calendar list between site collections may be confusing, but it is actually very simple! This article demonstrates one method using list templates and Windows Explorer to move SharePoint Calendars fast.  Don’t worry, all your content will be moved also.  Let’s begin: You must have proper permissions between the two site collections to perform [...]...
  2. SharePoint Browser Error Solution: Datasheet View Error Problem description: If a site has a document library using the Datasheet view a user will receive the following error when trying to navigate to the site. “The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows [...]...
  3. Custom SharePoint List Icons Recently I was asked by my manager to create a dashboard for executive members to quickly see the progress of active projects. She explained to me that she wanted a “priority level” indicator similar to that of the KPI in a basic table structure. The color of the indicator would change depending on the status [...]...
  4. Import Outlook Calendar to SharePoint SharePoint makes it very easy to export Calendars from SharePoint to Outlook.  But what if you have an Outlook calendar that you want on SharePoint?  This becomes more difficult and you could quickly find yourself lost on how to complete this task.  Don’t worry though, it’s not that hard.  The following article will explain a [...]...
  5. How to remove the “title” column from a SharePoint list Have you asked yourself the question: How do I remove the ‘title column’ from a Sharepoint list?  It can be annoying trying to figure out how to remove this column from default lists.  Often, site admins want their audiences to click on “New Item” in a Sharepoint list and not have to fill out the [...]...
  • Mike

    You are a genius Devin. This really helped me out. Also discovered that you can set to data type of the calculated column to “Date and Time”, “Date Only”. Which appears to have the same result.

  • http:/www.dlocc.com Devin Walker

    Cool, glad to help you out!

  • Nita

    how do you display date “Fri, Mar 12, 2010″

  • Tatiana

    Hi,

    only a part of this works for me. I need Start Date and End Date columns, which I have created. However, all start dates which had 12:00am time, moved one day earlier.
    Example: If my old START DATE & TIME column contained 4/6/2011 12:00am, my new DATE column would be 04/05/2011. I am not sure what to do with this. There are several people in our office that update the calendar and I can’t manually change each new event. 12:00am thing is a default time for All day events. I am not a programmer. Can you please advise? Thank you.

  • Willi

    I tried this frist part but when I go to Modify the Shared Webpart > Current View, I do not have the options to slecet the different fields. I am using SharePoint Services 3.0, would that have anything to do with it? Any advice would be greatly appreciated.

    THANKS

  • Chris

    Hi, this is great!
    Just one thing, when I get to the end I can’t ‘uncheck’ Start Time… I am using SharePoint 2007, would that be the difference?

    Thanks :)

  • http://www.facebook.com/tonyblandisbetterthanyou Tony Bland

    Brilliant. Thanks.

  • Lokie

    This works great, but I would love to be able to place it into a Calendar view… any ideas?