OMG I never thought about that and it totally makes sense... Rich, thanks... that will help out in so many instances...
~Terry -----Original Message----- From: Richard Kroll [mailto:[EMAIL PROTECTED] Sent: Monday, March 26, 2007 10:34 To: CF-Talk Subject: RE: date compare > #Fix( your_date )# will convert the date to a float, and then cut off > the hour/min/seconds... Then the CFQueryParam tag will convert the float > back into a date/time object. I guess you learn something every day! Nice tip Ben Rich Kroll ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273733 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4