I figured that out. But I have another question. This is the query I have. SELECT count(*), date(invoicedate) FROM Invoice WHERE Balance > 0 and Status = 'Posted' group by date(invoicedate) I want to also group by week in month. Like week 1, week 2, etc., Can you tell me how I can do that with the above query? Thanks!
... View more