I created a query to get the date for the week, but now I noticed that the date was from Sunday to Monday.
How can I start it from Monday to Sunday.
Here is my query:
SELECT DISTINCT r.report_date, r.process_id
FROM op_reports AS r
JOIN shift_list AS s ON (s.shift_id = r.report_shift)
JOIN process_list AS p ON (p.process_id = r.process_id)
WHERE WEEK(report_date) = '30'
GROUP BY r.report_date ORDER BY r.report_date ASC;
Thank you so much.