You could use a SQL BETWEEN or could just query for records with dates greater than 7 days past because sounds like you just want the past 7 days and not really Tuesday to Tuesday.
On Feb 3, 2008 11:09 AM, Don R Seibert <[EMAIL PROTECTED]> wrote: > Hello All, > > > > I would like to query my database for a date range from Tuesday to > Tuesday and return and retain the values. I do a private movie website > and the person would like to see DVDs that were release during the week. > Once that week is done. I upload new DVDs and then they are displayed. I > am not sure of how to set up the dates to reflect. Sure could use some > help on this. > > > > Thank you, > > > > Don Seibert > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:298027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
