Filter SharePoint (WSS 3.0/MOSS 2007) calendar by Start Time
Annoyingly the “Start Time” column doesn’t appear in filtered columns in WSS 3.0/MOSS 2007.
Heres a quick (maybe hacky?) way to solve the problem….I’m sure theres a sexier way but this works for me…
-
Open your Calendar list settings
-
Add new column, and call it StartFilter (for exmaple)
-
Select ”Calculated” as a the type of new column
-
In the Formula field insert:
=[Start Time] -
Select Date and Time as data type of new column
-
Make sure “Add to default view” checkbox is unticked
-
Save the new column
You should now be able to use the StartFilter column to filter your calendar list.