SharePoint Calendars: Remove the time for calendar items

The 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:

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 Settings
   
2. 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.
   
   
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.
   
5. Return to the page where your Calendar Summary View webpart is displayed and modify the webpart…
   
   and Edit the Current 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 Ok.
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 [...]...