Date comparison using ColdFusion

I am trying to query a table to extract information based upon date parameters entered by the user. For example, I want all work orders dated 01/01/2005 through 01/31/2005.

Here is the query I have tried but receive no output although I know that I should receive output.

<cfquery name="Table" datasource="facilities">
Select *
From issue_list
Where date >= #ti#
AND date <= #ti2#
</cfquery>

In my example from above,#ti# = 01/01/2005 and #ti2# = 01/31/2005. When I eliminate the AND date <= #ti2#, I receive output for all dates greater than the value of #ti#. Any ideas?

THANKS

This is actually a SQL issue. You could try using the createODBCDate() function on the dates to see if that makes a difference. But how date comparisons work is really specific to each database.