Database query

  • Thread starter Thread starter John
  • Start date Start date
J

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!!
 
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
 
Back
Top