Limiting Database Results by Date

C

Crush

I am having difficulty using the database results wizard.
We have a page that displays data for every day of the
year. What we would like to do is to have it just display
data for today and on. In Access, I would just set the
criteria to >=Date(). How can I do this in Frontpage
using the wizard?

Thanks
 
C

Crush

I have tried that already and unfortunately it gives me
the message: Description: [Microsoft][ODBC Excel Driver]
Too few parameters. Expected 1.

It is pulling the data from a spreadsheet. Is it possible
that it doesn't recognize the date field?
 
K

Kathleen Anderson [MVP - FP]

It's possible. How do you have it defined in the spreadsheet?

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


Crush said:
I have tried that already and unfortunately it gives me
the message: Description: [Microsoft][ODBC Excel Driver]
Too few parameters. Expected 1.

It is pulling the data from a spreadsheet. Is it possible
that it doesn't recognize the date field?

-----Original Message-----
The same way: WHERE (event_date>=Date())


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





.
Click to expand...
Click to expand...
 
C

Crush

I've tried different formats but want to stick with
MM/DD/YYYY. I've also ensured there are no blank fields
and even named the range 'Date'.


-----Original Message-----
It's possible. How do you have it defined in the spreadsheet?

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


Crush said:
I have tried that already and unfortunately it gives me
the message: Description: [Microsoft][ODBC Excel Driver]
Too few parameters. Expected 1.

It is pulling the data from a spreadsheet. Is it possible
that it doesn't recognize the date field?

-----Original Message-----
The same way: WHERE (event_date>=Date())


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


I am having difficulty using the database results wizard.
We have a page that displays data for every day of the
year. What we would like to do is to have it just display
data for today and on. In Access, I would just set the
criteria to >=Date(). How can I do this in Frontpage
using the wizard?

Thanks


.
Click to expand...
Click to expand...


.
Click to expand...
 
Top