Where clause doesn't work on date field
Posted on 2012-03-18
Dear all experts, I've a table which contains some a date field, when I run a query it cannot returns the value that I want, is there any thing wrong in my query?
Select * from Q_Analystz_Report where Type = 'C' contract_date > #01/03/2012#
I expect the above query can return the records which is larger than 1 Mar 2012 (record should up to 17 Mar 2012) but only one record returns.
Please note, the field is in DD/MM/YYYY format