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