VB6 with Access 2K database:

I want to compare whether does a field in a Table matched the
criteria. The date field was declared as Date/Time field.

How should the SQL statement be? Thanks.
(I tried SELECT * FROM Table WHERE FieldDate = #28/Aug/2000#
but can't retrieve any results, maybe the Time isn't there?
Can I use something like LIKE)