Search to exclude date range

[Adam R]

im using access 2k and asp

and im running a simple ASP Recordset SQL statement :

SELECT *
FROM virooms
WHERE dtdatefrom<=#date1# AND dtdateto>=#date2#

on the dbase : http://ceaseanddesist.chunkafunk.co.uk/23c_hot_bk.mdb

yet it returns nothing even when using US style dates, i also tried running
this as a query in the database with the same results


Ive trawled the net for answers and cant find anything so i presume its
something obvious im
missing ?

 

[Les]

What values are being used for date1 and date2? Do you
need 2 different date fields?

 

[Adam R]

yes

needs 2 diffrent dates as its checking wether there is someone in the room
between those dates