Cannot create calendar view with Distinct nodes

I am dttempting to modify the calendar view so it returns "distinct" nodes and includes value1(from) OR value2(to) of the CCK Date field in the Argument. When previewing or displaying the view I get a SQL Syntax error.

user warning: 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 'DISTINCT(node.nid), node_data_field_schedule.field_schedule_value AS node_dat' at line 1 query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node_data_field_schedule.field_schedule_value AS node_data_field_schedule_field_schedule_value, node_data_field_schedule.field_schedule_value2 AS node_data_field_schedule_field_schedule_value2, node.title AS node_title, node.changed AS node_changed, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, node.type AS node_type FROM node node LEFT JOIN content_type_event node_data_field_schedule ON node.vid = node_data_field_schedule.vid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid WHERE ((STR_TO_DATE(node_data_field_schedule.field_schedule_value, '%Y-%m-%dT%T') >= '2008-07-01 04:00:00' AND STR_TO_DATE(node_data_field_schedule.field_schedule_value, '%Y-%m-%dT%T') <= '2008-08-01 03:59:59')) OR ((STR_TO_DATE(node_data_field_schedule.field_schedule_value2, '%Y-%m-%dT%T') >= '2008-07-01 04:00:00' AND STR_TO_DATE(node_data_field_schedule.field_schedule_value2, '%Y-%m-%dT%T') <= '2008-08-01 03:59:59')) in /home/content/s/h/a/shantijoonu/html/drupal_dev/sites/all/modules/views/includes/view.inc on line 681.