Database query

[John]

Hi,
I am trying to query a database and have it return a list
from one date to another date. I have a SQL query that
works fine except for when I paste it into Frontpage.

I keep getting a syntax error. Here is part of it...
where d.batchstartdatetime>'Date'and
d.batchstartdatetime<'Date + 1' some more stuff....

The error is saying syntax near '>' which I think is the
way I am trying to get the system date. What I want to do
is to grab the system date and use it in the query so I
only get todays stuff.

Thanks for any help!!

 

[Kathleen Anderson [MVP - FP]]

Working with Today's Date in the Microsoft FrontPage® Database Results
Wizard
http://www.spiderwebwoman.com/tutorials/working_with_dates.htm

 

[John]

Thanks for the help. I did try to do as it said in the web
page but with no luck!

I keep getting the same error. It says syntax near '>'

Thanks

 

[Kathleen Anderson [MVP - FrontPage]]

Please post the SQL as it looks now.

--

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