SEARCHING BETWEEN DATES!

[LucyL]

Hi,
I want to check if one date is BETWEEN two other dates?
I tried using the DateDiff function but this just returns the number of months etc between two dates...
Does anyone know the syntax for searching BETWEEN two dates?

SELECT letting_finish
from Renter
where letting_finish BETWEEN date1 AND date2????

 

[cnealy]

Is this a SQL statemenet for an Access database? If so, the code that you wrote should work.

 

[CDL]

Hi,
For sql server , u can try something like this.
SELECT letting_finish
from Renter
where letting_finish BETWEEN (date1,date2).
Goodluck!