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]