You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and date_format(fldStartDate,'%Y-%m-%d') <='2010-07-31' group by fldSubscribedPr' at line 1