Filter with datefield

[menotti08]

hello people how can i make a filter with the date field please help me
i have this code if you intall coldfusion in your pc
you can run it, im using the cfartgallery database that coldfusion install



<CFQUERY NAME="nuevo" DATASOURCE="cfartgallery">
SELECT ORDERDATE, STATE, CITY, PHONE
from ORDERS
</CFQUERY>
<cfsavecontent variable="actionFilter">
if(_global.arrMembers == undefined) _global.arrMembers =
data.dataProvider.slice(0);
var arrMembers = _global.arrMembers;
var arrDisplay:Array = [];
var fortext = forInput.text.toLowerCase();
var selected = column.selectedItem.data;

for(var i = 0; i < arrMembers.length; i++)
{
if(arrMembers[selected].substr(0,fortext.length).toLowerCase() ==
fortext)
{
arrDisplay.push(arrMembers);
}
}
data.dataProvider = arrDisplay;
</cfsavecontent>

<cfform name="myForm" format="flash" width="700" height="500">
<cfformgroup type="panel" label="Search our Members">
<cfformgroup type="horizontal">
<cfinput type="text" name="forInput" width="120" onchange="#actionFilter#"
label="Filter by:">
<cfselect name="column" label="in:" onchange="forInput.text='" width="90">
<option value="state">state</option>
<option value="city">city</option>
</cfselect>
</cfformgroup>
<cfgrid name= "data" query="nuevo" height="200" rowheaders="false">
<cfgridcolumn name="Orderdate" header="Date">
<cfgridcolumn name="state" header="state">
<cfgridcolumn name="city" header="city">
</cfgrid>


</cfformgroup>
</cfform>

[Dan Bracuk]

What would you like this filter to do?

[BKBK]

>... how can i make a filter with the date

If d1 and d2 are two datetime objects and d3 a datetime column in a query,
Coldfusion allows you to play like this

- <cfif d1 GT d2>
- order by d3
- where d3 > GetDate()