FN-FORUM: SQL less than or equal to operator problem

date posted 13th January 2007 13:47

Hi

I've come across an issue to seems rather odd. I have a record in a
table that has a date field with the value of 13/01/2007 (today). The
field is called Generated date.

When I do this the record is not found:

WHERE GeneratedDate >= ' 13/01/2007 ' AND GeneratedDate = ' 13/01/2007 ' AND GeneratedDate = ' 12/01/2007 ' AND GeneratedDate