Re: drw date problem

Hi,
you'd need to surround the date with # # and also square bracket the field
name, eg

SELECT *
FROM Table
WHERE [Date] = #::date::#

if this is still failing try a query against a date you know is in the
database, eg
SELECT *
FROM Table
WHERE [Date] = #::7/20/2004::#

--
Cheers,
Jon
Microsoft MVP - FP

"Hayden Greg" <HaydenGreg@discussions.microsoft.com> wrote in message
news:E63CE5DD-4496-4A7E-B022-7546BFC8B4EF@microsoft.com...
> Using DRW and Access I created a search page that will not work when I add
the date as the search criteria. The access field is set up as a short date
7/20/2004. Using DRW I tried a custom query
>
> SELECT * FROM LAB
> WHERE (DATE = ::date:
>
> On my search page when I place a date in my search field I get
> No Records Returned
>
> So, then I tried it without a custom query. In DRW I tried adding criteria
under more options ( date = date). I got the following error when putting in
a date on my search page.
> Data type mismatch in criteria expression.
> Number: -2147217913 (0x80040E07)
> Source: Microsoft JET Database Engine
>
> I would also like to create a search where you can put in a range of dates
that looks at one field in access.
>