I have an access database and working with vb 2005.
I have one date column which is in MM/dd/yyyy format
but my problem now is that
if i search for date less than (it will use the month alone.) here is my code for search criteria.
search = "Select * FROM tablename WHERE cdate([Date Sent]) > '09/21/2009';"
if my date sent has 10/15/2009, 09/21/2009, 09/27/2009.
the result is given me is 09/27/2009 alone instead of
09/27/2009 and 10/15/2009
please what do i do