Date Searches

Hi Ross,

Thanks for looking at this. It's a pretty simple page.

Just a listing page with 2 date format fields... A start date date field and and end date field, a title, an image, and a short description of the event. (Right now the date fields are still text fields)

You can see it at:
www.artistsofpalmbeachcounty.org/events.php

Thanks,

Jerry

Hi Jerry

Thanks for the link :).

I am actually thinking that instead of setting up a bunch of search code, use the built in "removeDate" function.

To use this, just change the field name of your end date to "removeDate" (for both the label and the field name) and that should be it.

From there, your items will only be displayed if the current date before what you select in that field.

CMS Builder will automatically stop showing them once the event is over.

Give this a shot and let me know how you make out :).

Good afternoon Ross,

I think you may have been misled by the way I described the situation.

In the above, let's say a user searches for "April" events as their search criteria and the start date of an event is in "March" and the end date is in "May".

I'm assuming that an "April" listing won't show in the result list unless I've programmed the search to show any "Month" that matches the start date month, or the end date month, or that is between a start date month and the end date month?

I just don't have a clue how to do that.

Thanks,

Jerry

Hi Jerry

I think what you are running into here is that CMS Builder searching is "AND" based. So when you do a search with both the start and end date, the search is like this:

find me all listings that have a start date after tuesday AND an end date before Friday. Listings that have an end date after Friday, won't show up.

What you could do is have the search only check the start date, or just make sure your end date encompasses all the possible dates you would like.

Does that make sense?