Re: drw date problem

You have to surround the date with #

Date = #::date::#
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"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.
>

I am having the same problem with Front Page 2003.

When I try your solution to surround the date with #
SELECT * FROM Events WHERE (Date_Submitted = #:ate_Submitted::#)

I get the following error

Server error: Unable to retrieve schema information from the query:

SELECT * FROM Events WHERE (Date_Submitted = #1#)

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/BPR.mdb.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query
expression '(Date_Submitted = #1#)'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)
"Thomas A. Rowe" wrote:

> You have to surround the date with #
>
> Date = #::date::#
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "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.
> >
>
>
>

This:
http://support.microsoft.com/defaul...&Product=fp2002
should help.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"Brian" <Brian@discussions.microsoft.com> wrote in message
news:3D02FE96-D09C-466C-9A33-AA25874BA07A@microsoft.com...
>I am having the same problem with Front Page 2003.
>
> When I try your solution to surround the date with #
> SELECT * FROM Events WHERE (Date_Submitted = #:ate_Submitted::#)
>
> I get the following error
>
> Server error: Unable to retrieve schema information from the query:
>
> SELECT * FROM Events WHERE (Date_Submitted = #1#)
>
> against a database using the connection string
>
> DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/BPR.mdb.
>
> The following error message comes from the database driver software; it
> may
> appear in a different language depending on how the driver is configured.
> -------------------------------------------------------
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query
> expression '(Date_Submitted = #1#)'.
>
> Source: Microsoft OLE DB Provider for ODBC Drivers
> Number: -2147467259 (0x80004005)
> "Thomas A. Rowe" wrote:
>
>> You have to surround the date with #
>>
>> Date = #::date::#
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WEBMASTER Resources(tm)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>>
>> "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.
>> >
>>
>>
>>