Problem with views_handler_fields_dates and nodereference

I've identified the problem.

First I changed the datatype from VARCHAR to DATE in the field_m_date_value column. This way the T00:00:00 disappeared.

But, when I use a filter I get this query:

...
WHERE (node.type IN ('member'))
AND (content_type_event.field_m_date_value = '1211432400'.
...

In this case and with this query Views returns nothing. If I paste the query into a query browser I get an error:

Incorrect date value: '1211432400' for column "field_m_date_value' at row 1

if I change the query in the query browser to this:

...
WHERE (node.type IN ('member'))
AND (content_type_event.field_m_date_value = '2008-05-22'
...

Everything works the way it should.

So the problem is that when I use a filter and type '2008-05-22' views (or php) translates this to '1211432400' and somehow mysql can't display this correctly.

I see to possible solutions for this: the first one is to avoid views from converting '2008-05-22' into '1211432400' (how do I do this?).. The other one is to find out why mysql can't get the value 1211432400 as a correct date.

I must say that if I use a filter for the node's created date and views translates '2008-05-22' to 1211432400 everything works fine. I don't know why in one case it does works (node's created date) and it doesn't for the other one (field_m_date_value).

Any help?

Thanks

Luis

Solved. I erased the field field_m_date_value, this one was a date and created another one with the same name but this new one was Datestamp. Problem solved. I had a little issue with the date because it was being showed 1 day before the actual date but this was apparently a problem with my time zone (-6), i just changed this and everything is working great. I can use filters and i changed the date handler to views_handler_fields_dates instead of views_handler_fields_dates_iso.