Friday, July 10, 2009

Filtering SharePoint calendar by Start Time

Trying to filter WSS 3.0 calendar list by Start Time column. This column doesn't appear in filtered columns list. I found solution that is a workaround, but at least it solved my problem. So,

Let's go step by step:
  1. Open Calendar list settings.
  2. Add new column called (by example) Begin.
  3. Choose "Calculated" as a type of new column.
  4. In the Formula field insert the following formula:=[Start Time]
  5. Select Date and Time as data type of new column.
  6. Clear check from "Add to default view" checkbox.
  7. Save the new column.
  8. Now you should be able to use the column called Begin instead of Start Date when you need to filter calendar list.

No comments:

Post a Comment