Search Between Dates Problem

can you post the form that creates form.depdate1 and form.depdate2? I've got a form in an admin system for a client to look up events between entered dates: cfif IsDefined(form.depdate1) AND #form.depdate1# NEQ cfset DEPDATE1 = #CREATEODBCDATE(form.depdate1)# cfset DEPDATE2 =

Search Between Dates Problem

I've got a form in an admin system for a client to look up events between entered dates: cfif IsDefined(form.depdate1) AND #form.depdate1# NEQ cfset DEPDATE1 = #CREATEODBCDATE(form.depdate1)# cfset DEPDATE2 = #CREATEODBCDATE(form.depdate2)# /cfif and in the query: WHERE ENROLL_DATE