[Solved] view filter : field date and now

Hello,

I'm trying to add a filter in a view which is based on two fields to be compared with now() value.
I suppose this is a quite easy requirement...but it doesn't work unfortunately.

Looking the SQL query (produced by view editing fnctionalities and printed hereafter) indeed values are compared with ''2009-01-01'.
I presume this should be a now() value. Looks like now() relies only on year, not month and day.

My version is 6.10 (had same problem with 6.9).

Thanks for any clarification or clue.
Bye,
Bruno

SELECT node.nid AS nid,
node.title AS node_title,
node_data_field_date.field_locationcck_lid AS node_data_field_date_field_locationcck_lid,
node_data_field_date.nid AS node_data_field_date_nid,
node.type AS node_type,
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
FROM node node
LEFT JOIN content_type_event_type node_data_field_date ON node.vid = node_data_field_date.vid
WHERE ((DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), '%Y-%m-%d') >= '2009-01-01') AND (DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value2, '%Y-%m-%dT%T'), '%Y-%m-%d') >= '2009-01-01'))
AND (node.type in ('event_type'))
ORDER BY node_data_field_date_field_date_value ASC

Edited by WorldFallz - added '[Solved]' to title.