Date Searches

Hi Jerry

Thanks for posting!

Could you show me the page you are doing your searching on? I'd like to see how you have it setup :).

We do date searching fairly often for things like expired articles so there should be an option for you here.

Let me know :).

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