search between dates

Hi

I have a successful search form for a variety of criteria - except when it searches between 2 dates.

The appropriate code, I think, is as follows:

$WADbSearch1->addComparisonFromEdit("pages.StartDate","S_StartDate"," AND",">=",2);
$WADbSearch1->addComparisonFromEdit("pages.EndDate","".((isset($_GET["S_EndDate"]))?WAQB_getEndDate($_GET["S_EndDate"]):"") ."","AND","<=",2);

It finds matching results greater than S_StartDate but ignores the S_EndDate parameter, and shows all records that have an entry beyond the S_StartDate

Hope this is a quick/easy fix!

Many thanks

Chris

I'll need to troubleshoot directly, see the private message section.

pm

see PM

pm

This post has been deleted.

pm

i changed the end date code to:
$WADbSearch1->addComparisonFromEdit("pages.EndDate","S_EndDate","AND","<=",2);

not sure why the $_GET code was inserted, it was not needed.

Thanks very much, Jason.

you're welcome