John Beynon wrote: > should i be able to do date comparisons in a QofQ?
Yes. But unfortunately it is impossible to use date objects directly in "pass through" QofQ's, so you have to fake a prepared statement with cfqueryparam or just use a string representation of a date. In your case, you should be able to use: <cfquery name="FilteredBlogArticles" dbtype="query"> Select * from BlogArticles where articledate >= <cfqueryparam cfsqltype="cf_sql_date value=""#FilterDate#"> order by articledate DESC </cfquery> Or: <cfquery name="FilteredBlogArticles" dbtype="query"> Select * from BlogArticles where articledate >= '2002-10-01' order by articledate DESC </cfquery> Jochem ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists