mysql error adding date argument to a view

i get a mysql error when adding a date argument of a cck field to a view. the error is the following:

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 'AS node_data_field_programm_datum_, node.sticky AS node_sticky, node_data_' at line 4 query: SELECT COUNT(*) FROM (SELECT node.nid AS nid, node_data_field_programm_datum.field_programm_datum_value AS node_data_field_programm_datum_field_programm_datum_value, node_data_field_programm_datum.field_programm_datum_value2 AS node_data_field_programm_datum_field_programm_datum_value2,
node_data_field_programm_datum. AS node_data_field_programm_datum_,
node.sticky AS node_sticky, ..........

it doesn't matter which granularity i choose - the error always appears because of this line:
node_data_field_programm_datum. AS node_data_field_programm_datum_,

which should look like this:
node_data_field_programm_datum.field_programm_datum_value3 AS node_data_field_programm_datum_field_programm_datum_value3,

any help would be appreciated