Jerry: We do this exactly at:
http://www.WeeklyRentals.com Jim > I'm not sure if this gets you all the way, or not. > > There is a WEEK() function that converts a date into its week of the year. > There isn't any obvious way to turn it back into a date, but it doesn't > sound like you need it for your particular application. > > SELECT * FROM specials WHERE WEEK(NOW(), 7) = WEEK(specials.start_date, 7) > AND DATEDIFF(specials.start_date,DATE(NOW)) < 7; > > Since you have the start date for your special, then you will be getting > it > back from your query anyways so you don't need to convert back. You can > make > your queries more efficient if you store the week the special starts as > well > as its date, saving one function call in your query and allowing you to > index on that week field. > > The second part of the WHERE clause should keep you within the right year, > if I did it correctly. > > > Regards, > > Jerry Schwartz > Global Information Incorporated > 195 Farmington Ave. > Farmington, CT 06032 > > 860.674.8796 / FAX: 860.674.8341 > > >> -----Original Message----- >> From: Joey [mailto:[EMAIL PROTECTED] >> Sent: Thursday, March 29, 2007 9:46 AM >> To: MySQL DB >> Subject: Help With a Week ( date ) query >> >> Hi Guys, >> >> I'm kind of at a standstill in coming up with how to get a >> query I need to >> write. >> I'm trying to find a record which matches the week we are in. >> Example today is Thursday the 29th, it is within the week >> which has the 26th >> through the 1st, and if the day is within this week display >> the record that >> has the date 3/26/2007. >> >> Basically we are returning a special which is dated each >> Monday, any day >> within that week should show the Monday value. >> >> I appreciate your help! >> >> Joey >> >> >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> >> > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]