Hi Guys, i have a few drop down menus for my search function but cant seem to get my date range to work. For date i have two field with a jQuery date picker to choose the date.
Here is the search code:
Here is the code for the date fields used:
It will work if i want to search for one date, what i have to do is put the same date into both fields and it works.
Can someone help please![Smile :) :)](/styles/default/xenforo/vbSmilies/Normal/smile.gif)
Here is the search code:
Code:
$QBuild = "";
$QBuild = "SELECT * FROM ($table) WHERE upper($field)";
if($Date1 && $Date2 != NULL){
$QBuild = $QBuild."AND (Date BETWEEN '$Date1' AND '$Date2') ";
}
if($Initials != NULL){
$QBuild = $QBuild."AND (Initials LIKE '$Initials')" ;
}
if($PassFail != NULL){
$QBuild = $QBuild."AND (PassFail LIKE '$PassFail')" ;
}
Here is the code for the date fields used:
Code:
Search by Date: <input name="Date1" type="text" id="datepicker" /> and
<input name="Date2" type="text" id="datepicker1" />
<Select NAME="field">
<option value="Date">Date</option>
</Select>
It will work if i want to search for one date, what i have to do is put the same date into both fields and it works.
Can someone help please
![Smile :) :)](/styles/default/xenforo/vbSmilies/Normal/smile.gif)