The >= statement below returns rows, but when I add the 2nd statement I get nothing. Is there a better syntax to use with MySQL 4? The <= doesn't work by itself either. Looks like <= can't be used at all.
AND CloseDateTime >= '08/01/2007' AND CloseDateTime <= '12/31/2007'
Assuming CloseDateTime is a MySQL date, datetime, or timestamp type, you need to use year/month/day formats for your literal date values:
AND CloseDateTime >= '2007-08-01' AND CloseDateTime <= '2007-12-31'
Better to use BETWEEN
