I am trying to find out the qty of items invoiced this week.

I can get the last 7 days with the following query:

SELECT SUM(quantity) from invoices WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= inv_date

My problem is that on Monday morning I need the qty to start at 0 again but the above will include part of last week.

Can anyone help with this?

Thanks...

depending on what front end you are using you may be able to do what you want more esaily.

But in MySQL there are several date functions that may help
dayofWeek() will return todays day Sunday=1, Saturday=7
weekday()
date_add()
date_sub()
-if you are using version 5 then your could write sproc to handle it otherwise you will have to write a fairly convluted SQL statement
HTH

Sounds like you want to group by the week of the year?

Check out the date and time functions. You may want to look at WEEK() and WEEKOFYEAR().

Darn it, I always forget to post the version number that I am using

Thanks for the pointers. I think I may have a solution in mind, I just have to play with it a little

if thats a problem just create a signature admitting to what versions of what you are using - it removes some of the doubt on trying to help.