>>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.
My FieldDate field is a Date/Time type and it stores date and time.
If I use the = #2000/08/28# it will not have a match as well.
How to go about matching the date only and ignore the time? Thanks.