I know I'm missing something here...I have a CF form that I want the user to be able to input a date range and then the query results will return the data between that range. This is the part that is not functioning....what am I doing wrong?
It's an ACCESS dbase and the fields are date/time in the table. The form looks like this:
|_| Checkbox - ___________________ to ____________________
The code looks like this:
<CFIF IsDefined('form.DateRequestedRange') And CompareNoCase(form.DateRequestedRange,"No") NEQ 0>
AND DateRequested >= LIKE <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#form.DateRequestedFrm#%"> AND <= LIKE <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#form.DateRequestedTo#%">
If the user inputs this into the form:
|X| 10/01 to 10/30
The the results should be anything in the table that has a request date from 10/01 to 10/30.