guess BETWEEN and DATEADD might help; BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL -7 DAY)At the moment all my data is in SQL Server and would like to stay with this solution. Just looking for a SQL query to group the data by day/week/month/year...
google is your friend for further solutions like; last week, last month, this month etc,...