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:298029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
