>>>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.
Enter directly in Access to build your query with the visual builder. Then look at the SQL query.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com