Hello..It looks to be a simple question but it has taken alot of my time: I am trying to find two value between two dates but it doesnt seem to work. It gives me result with all the values..my code is :

Date(EMAIL.DATE ) >= '2010-12-01'
AND
Date(EMAIL.DATE ) <= '2013-12-31'

I also tried :
Date(EMAIL.DATE ) = CHAR(TIMESTAMP( '2011-12-01-00.00.00'))
AND
Date(EMAIL.DATE ) >=...