SharePoint: Creating a calendar next events view

18 Jun 2009

To create a view on a calendar in SharePoint which will display the 5 upcoming events, proceed as described below:

  • Add a column to your Calendar, name it “Begin”. This will be a calculated column. The formula used will be: “= [Start Time]” (without qoutes, but with [ and ] ). The data type returned will be “Date and Time”, and choose “Date Only” as the date time format.
  • Create a new view on the calendar named “Next events”. In this view I choose only to display Title, Start Time and End Time.
  • Sort this view by the column: Begin
  • The Filter of the view is set to:
    - Show items only when the following is true
    - Begin is greater than or equal to [Today]
Share This:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • LinkedIn
  • PDF
  • Twitter

Comment Form