The BETWEEN would work fine for that or if your database has the datediff function then you could go that route. Each database has its own unique set of date functions along with some common ones so it is hard to say which one of those will work for you or not without knowing your database. Regardless to the best of my knowledge they all have the BETWEEN. So you can figure out your Tuesday dates either off the system date in your database or via CF and then use those on either end of the BETWEEN.
On Feb 3, 2008 12:11 PM, Don R Seibert <[EMAIL PROTECTED]> wrote: > I guess I should provide a little more info. The Tuesday to Tuesday > thing is a sliding window. Each week will be new DVDs that will be > available only for the Tuesday to Tuesday time frame. Then a new set of > DVDs will be uploaded and available for the next Tuesday to Tuesday time > frame. So I only want to display DVD titles during that time that fall > within that time frame. Sorry if this sounds confusing as I am trying my > best to explain. > > Donald Seibert > > -----Original Message----- > From: Dominic Watson [mailto:[EMAIL PROTECTED] > Sent: Sunday, February 03, 2008 1:55 PM > To: CF-Talk > Subject: Re: Query for a particular date range > > > > > I would like to query my database for a date range from Tuesday to > > Tuesday and return and retain the values > > > There is BETWEEN: > > SELECT theDataIWant FROM theTable WHERE theDatefield BETWEEN > '2008-01-27' AND '2008-02-03' > > Or DateDiff(): > > SELECT * FROM theTable > WHERE DateDiff(d, theDatefield, '2008-01-27') <= 0 > AND DateDiff(d, theDatefield, '2008-02-03') >= 0 > > > The greater than and less than may need to be the other way round, I > never > can do be sure without testing. > > HTH > > Dominic > -- > Blog it up: http://fusion.dominicwatson.co.uk > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
