Query of Query with dates

Using ColdFusion5. Is there a secret to working with dates in a query of a query? I keep getting zero rows from any date comparision I do in a WHERE clause. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard

Re: Query of Query with dates

A fast search pulled up a mention that this works for the same problem in early MX releases. Might work in 5 cfqueryparam value=#someDate# cfsqltype=CF_SQL_DATE Using ColdFusion5. Is there a secret to working with dates in a query of a query? I keep getting zero rows from any date