Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is this Date Constraint format correct?

Status
Not open for further replies.

mwh2

Technical User
Joined
Mar 31, 2004
Messages
1
Location
US
Thanks in advance to anyone that can look at this code and tell me if I'm missing any thing. I can't get it to work.

$this->constraints .= "vehicle_reservations.start_date NOT BETWEEN '".$dates[0]."' AND '".$dates[1]."' AND
vehicle_reservations.end_date NOT BETWEEN '".$dates[0]."' AND '".$dates[1]."' AND ";
(vehicle_reservations.start_date IS NULL AND vehicle_reservations.end_date IS NULL)) AND";

Thanks,
Mh
 
Not really my area but you seem to have 2 closing brackets and only one opening bracket also there is an AND at the end but nothing there 2 and ? I think
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top