Cant get calendar to display date fields

Created a content type (Zmanin) to display in calendar. only filter on type and published. "to" field is enabled for the field type but set to NULL. Argument is set to day as default to time and is the same field as field to display.

SQL code wants to select From"<= '2011-01 AND to >= '2011-01'. nothing ends up in calendar....
SQL code below. Please help, I'm lost...

SELECT node.nid AS nid, node.title AS node_title, node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2, node.type AS node_type, node.vid AS node_vid FROM d5node node LEFT JOIN d5content_field_date node_data_field_date ON node.vid = node_data_field_date.vid WHERE ((node.type in ('zmanim')) AND (node.status <> 0)) AND ((DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), '%Y-%m') <= '2011-01' AND DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value2, '%Y-%m-%dT%T'), '%Y-%m') >= '2011-01')) ORDER BY node_data_field_date_field_date_value ASC