>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)

Most of the time, the ISO format works well:

SELECT * FROM Table WHERE FieldDate = #2000/08/28#

You can't use the Like operator since argument isn't string.