date range

Hi,

I'm having a Search page and a result page.
I would like the result page to display result according to a range of date I will put in two text box, labelled Date1 and Date2. If nothing or only one date is entered all the records should appear.

Here's what I came up with:

<cfif IsDefined("Date1") AND #Date1# AND IsDefined("Date2") AND #Date2# NEQ "">
BETWEEN #Date1# AND #Date2# = Nextinspectiondate
</cfif>

Nextinspectiondate : is the field where the date is stored.

When I try using this line I'm getting the message : can't transform value in boolean or something of the like. I've tried different format but always get an error message of somekind.

If possible I'd like to enter the date as : dd-mm-yyyy

Any ideas?
Thanks