select * where $date1 < dateCol and $date2 > dateCol