C. W., I don't know much about SQL server in particular, but try using 'date' instead of 'datetime' in your CONVERT function, if that's possible. I've run across this before in MySQL.
This is because a value like '2007-08-02 14:00:00' is greater than '2007-08-02', so that won't be picked up by less than or equal to. -- Josh ----- Original Message ----- From: "C. W. B." <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Wednesday, August 08, 2007 5:37 PM Subject: Re: SQL Server problem getting records within date range > Hello again Janet... > > I am so sorry to be bugging you again on this, but I am having trouble > with this new query - not doubt it's something I just don't understand. > > If I set the dates in this query to 08/01/2007 and 08/02/2007 I only get > results from 08/01/2007. And, if I have them both set to 08/02/2007, I > don't get no results at all - but I would expect to set the results from > 8/2, which do indeed exist. > > Note that I am using >= and <= in the query. > > What am I missing here? > > Feeling kinda dumb today.... :( > > >>Yes, that looks correct. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285782 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
