A date filter is a convenient way of filtering content between two dates. A date filter is specified with one column name and two content values - a start date and an end date.
<cfscript> // get the datasource ds = request.DataFaucet.getDatasource(); // create a select statement stmt = ds.getSelect("*","tblEmployee emp"); // filter by employee hire date stmt.dateFilter("hiredate",form.startdate,form.enddate); // get the results query = stmt.execute(); </cfscript>
The 2nd content value of a date filter can also be numeric indicating a specific number of days. For example to filter new hires within a particular week, you might use:
<cfset stmt.dateFilter("hiredate","1/1/2008",7) />
If you omit the 2nd content argument, it defaults to 1-day, so to get new hires on a specific day, from 12-midnight to midnight of the following day, you could simply use this:
<cfset stmt.dateFilter("hiredate","1/1/2008") />