Hi, at the moment I have the following code which pulls out records for the current day (using PHP).
Can someone please tell me how to get records for the current week and also the current month?
Please note that this database will be used across different timezones and in different countries.
SELECT * FROM leadscustomersdetail INNER JOIN leadscustomers ON leadscustomers.Lead_No = leadscustomersdetail.Lead_No WHERE leadscustomersdetail.ClosureDate >= CURDATE()
AND leadscustomersdetail.ClosureDate < DATE_ADD(CURDATE(), INTERVAL 1 DAY)