First of all I would use a "real" date object using CreateOdbcdate ( CreateDate(yyyy,mm,dd) ) The CFIF inside a cfquery is for sure working... using that quite often...
/Mats/ -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
