Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Calendar Start Date not a field in filter drop down

Asked By: Melissa Lewis Date: Jun 23, 2007 Category: Sharepoint Views: 1487

On our home page, I want a small calendar listing upcoming events. To
do this, I need to filter where the Start Date >= [Today].

However, Start date is not a column in the Filter drop down list. I've
tried creating new views, creating new calendars, changing the view
format, starting with an existing view. It just doesn't show up!

This is quite possibley the most critical field for a caledar. Why
isn't it one that I can filter on?

Tagged:calendar start date not field in filter drop down

8 Answers Found

Answer #1 Answered By: Lalit Bhattacharya Answered On: Jun 23, 2007

In SPS 2003 the Start Field is actually labeled "Begin" in the filter
interface.

Answer #2 Answered By: Gwendolyn Acosta Answered On: Jun 23, 2007

I should have specified that we are on MOSS 07. Start date and Begin
date are not in my calendar filter drop down.

Any other thoughts?

Answer #3 Answered By: Kyle Hernandez Answered On: Jun 23, 2007

As a workaround - In your calendar list, create a new column
called "myStartDate" as a calculated column with the formula set to =
[StartTime], data type as date and Time and the Date and Time Format
as Date Only.

Then use the myStart Date column as your filter field.

Answer #4 Answered By: Kedar Phule Answered On: Jun 23, 2007

This is what was told to Tony to do. We have done this and get and
error when putting the Colum into the Cutsom colums Site libraries
and lists, Customize calander. The error that I am getting is,- The
formula contains reference(s) to field(s). Any suggestions??

Answer #5 Answered By: Chanel Gaines Answered On: Jun 23, 2007

Can you give me a little more information about your error. Is it
occurring when you create the field, after you enter the formula,
when you are entering data, when you try to set a filter?

Answer #6 Answered By: Timmy Whitney Answered On: Jun 23, 2007

I have created the colum so the field is set. When I add the colum to the
calander list so that I am able to filtter is when I get the error. So it allows
me to create the column but not add it to the customized list for the calander.
Any suggestions??

Answer #7 Answered By: Harihar Sonnad Answered On: Jun 23, 2007

Maybe I have not had enough coffee this morning, but I'm not sure
what you mean by "add it to the customized list for the calender"

The solution I suggested is for a calendar list so from a Calendar
list, select: Settings » List Settings

On the Customize page, under the Columns section, select: Create
Column.

On the Create column page, Enter the following:

Name and Type »

Column name: myStartDate
The type of information in this column is: Calculated

Additional Column Settings »

Description: My calculated start date
Formula: = [Start Time]
The data type returned from this formula is: date and Time
Date and Time Format: Date Only

Click OK

You should now see the MyStartDate column in the list under the
Columns section on the Customize page.

From this point, when you are modifying a view of this calendar list,
you should be able to select the MyStartDate column as the filter
column.

Answer #8 Answered By: Deven Gajjar Answered On: Jun 23, 2007

When i say ok it gives
me the Error. I am in the customize calander create columns.

Didn't find what you were looking for? Find more on Calendar Start Date not a field in filter drop down Or get search suggestion and latest updates.