Date comprassion not showing data in the expression for datatable

There is a column in my data table that some dates in (MM/dd/YYYY) format .

Lets say i have date of period june/1/2009 to may/1/2010 i am giving some expression to filter the data.

lets say the filter expression clubs two months and project the data further the p开发者_高级运维roblem is projection work fine till this period Nov/1/2009 to dec/31/2009 but when it enters the new year there seems to be no match though the data is there.

CompositeDate
#06/01/2009#
#07/01/2009#
#08/01/2009#
#09/01/2009#
til dec
#01/01/2010#
#02/01/2010#

' # is appended to specify the ending and beginning of string '.

expression =  [CompositeDate] >= #01/01/2010# And [CompositeDate] <= #02/28/2010# 

this is the expression in which it is not showing data.