Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Calendar Start Date not a field in filter drop down

  Asked By: Melissa    Date: Jun 23    Category: Sharepoint    Views: 8744

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?



8 Answers Found

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

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

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

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

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

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

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

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

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

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

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

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.