Date search and compare

[MetroToday]

I have two date fields in my database which are called Datefrom and Dateto.

I am quering this database to retrieve a date that is greater than datefrom and less than dateto. So its in the middle of these two dates. I am all messed up with the syntax. Below is the SQL code.

SQLtxt = &quot;SELECT * FROM tbldata WHERE DateFrom < # &quot; & Request.Form(&quot;Date&quot & &quot;#&quot; AND WHERE Dateto > # &quot; & Request.Form(&quot;Date&quot & &quot;#&quot;

Someone help me fix up this code. PLEASE!!!

 

[Bastien]

SQLtxt = &quot;SELECT * FROM tbldata WHERE DateFrom < # &quot; & Request.Form(&quot;Date&quot & &quot;#&quot; AND Dateto > # &quot; & Request.Form(&quot;Date&quot & &quot;#&quot; Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[MetroToday]

It still giving me a syntax error. Below is the error its giving me:

Syntax error

SQLtxt = &quot;SELECT * FROM tbldata WHERE DateFrom < # &quot; & Request.Form(&quot;Date&quot & &quot;#&quot; AND Dateto > # &quot; & Request.Form(&quot;Date&quot & &quot;#&quot;


It does not like pound sign after Date >

 

[Tarwn]

Minor problems with the quotes, try this:

SQLtxt = &quot;SELECT * FROM tbldata WHERE DateFrom < #&quot; & Request.Form(&quot;Date&quot;) & &quot;# AND Dateto > #&quot; & Request.Form(&quot;Date&quot;) & &quot;#&quot;

Hope that helps,
-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
For my next trick I will pull a hat out of a rabbit (if you think thats bad you should see how the pigeon feels...)