php – Count the records of a single month

I'm doing a simple query to get the records of a single month, in my case of the current month. I have a table that saves the date in format 17.12.2014 01:12 because the customer has asked so.

What I try is this:

Query ("SELECT * FROM PrReserv WHERE date = & # 39;" $ date. "& # 39;");

echo "Number of records this month:". $ sql_cuenta-> rowCount ();
?>

But I get the result 0 when should it be 8thThese are the 8 records that are saved. Thank you