Query comparing dates

[lbrechler]

I'm sure this must be an FAQ, but I can't seem to find it...

I'm using VB6 to query an Access 2000 database. I want to pull all records from a particular table "TEST" whose field "DATE" is greater than today (basically, in the future). I thought that

"SELECT * from TEST where DATE > " & FormatDateTime(Now, vbShortDate)& " ORDER BY DATE ASC"

was working, but today when I check, there are no results (even though there should be at least 3).

Any suggestions?

Thanks,
Lindsay

 

[lbrechler]

Think I figured it out...

I actually had: "SELECT * from TEST where rst!DATE > " & FormatDateTime(Now, vbShortDate)& " ORDER BY DATE ASC "

But needed:

"SELECT * from TEST where CDate(rst!DATE) > " & FormatDateTime(Now, vbShortDate)& " ORDER BY DATE ASC "