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 comparision I do in a >WHERE clause. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282424 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
