Date Range Search

[TheScarecrow]

I have a calendar search from where an option is to search between dates and
riight now it never finds anything. Do I need to do a format conversion? or
do I need to do something to the CFOUTPUT to get it to work? Any idea. thanks.
(MSACCESS db)

<cfapplication SESSIONMANAGEMENT = "Yes">
<cfif session.marker_find EQ 1>
<cfset session.marker_find = 0>
<cfif IsDefined("Form.description")>
<CFSET SESSION.Cf_description = FORM.description>
<cfelse>
<CFSET SESSION.Cf_description = " ">
</cfif>
<cfif IsDefined("Form.category")>
<CFSET SESSION.Cf_category = FORM.category>
<cfelse>
<CFSET SESSION.Cf_category = " ">
</cfif>
<cfif IsDefined("Form.months")>
<CFSET SESSION.Cf_month = FORM.months>
<cfelse>
<CFSET SESSION.Cf_month = " ">
</CFIF>
<CFIF IsDefined("Form.fromdate")>
<CFSET SESSION.CF_fromdate = FORM.fromdate>
<CFELSE>
<CFSET SESSION.Cf_fromdate = "">
</cfif>
<CFIF IsDefined("Form.todate")>
<CFSET SESSION.CF_todate = FORM.todate>
<CFELSE>
<CFSET SESSION.Cf_todate = "">
</cfif>
</cfif>
<CFQUERY NAME="calendarresult" DATASOURCE="source">
SELECT *
FROM event_cal
WHERE public=yes
<!---search by Description--->
<CFIF #SESSION.Cf_description# GT " ">
AND title LIKE '%#SESSION.Cf_description#%'
</CFIF>
<!---search by Category--->
<CFIF #SESSION.Cf_category# GT " ">
AND category = '#SESSION.Cf_category#'
</CFIF>
<!--- search by Month--->
<CFIF #SESSION.Cf_month# GT " ">
AND event_date LIKE '#SESSION.Cf_month#%'
</CFIF>
<!---search by Date Range--->
<CFIF #SESSION.Cf_fromdate# GT " " AND #SESSION.Cf_todate# GT " ">
AND event_date BETWEEN '#SESSION.Cf_fromdate#' AND '#SESSION.Cf_todate#'
</CFIF>
ORDER BY event_date
</CFQUERY>

[jorgepino]

if your cf_month is eq MM and your event_date is eq to DD/MM/YY they will never equal
try this cf_month = #DatePart("m", event_date)#

[TheScarecrow]

The month and date range search are seperate.

[tjfrevert]

AND event_date BETWEEN #createODBCDate(SESSION.Cf_fromdate)# AND #createODBCDate(SESSION.Cf_todate)#