<!--- create a dummy query using queryNew --->
<cfset news = queryNew("id,title, date", "integer,varchar,date")>
<cfset queryAddRow(news)>
<cfset querySetCell(news, "id", "1")>
<cfset querySetCell(news, "title", "Dewey defeats Truman")>
<cfset querySetCell(news, "date", "Dewey defeats Truman")>
<cfset queryAddRow(news)>
<cfset querySetCell(news, "id", "2")>
<cfset querySetCell(news, "title", "Men walk on Moon")>
<cfset querySetCell(news, "date", "Dewey defeats Truman")>
<cfset writeDump(news)>

<!--- run QofQ (query of query) --->
<cfset new_date = now()>
<cfdump var="new_date">
<cfquery name="sortedNews" dbtype="query">
    SELECT id, title, date FROM news
    WHERE date<<CFQUERYPARAM VALUE="#new_date#" CFSQLType="CF_SQL_timestamp">
</cfquery>
<cfset writeDump(sortedNews)>