Sales stats this week/month/year pointers?
I am trying to create a basic stats page but not sure how to go about it. I want to pull up sales totals (number of orders and $ value) from eCart
I'm thinking... SELECT * FROM orders WHERE OrderDate <= 'midnight last monday'
Not sure how to describe 'midnight last monday' or 'the first of the month'
Can anybody give me a few pointers please?