How to get all the data before the current date and data for the next 3 days from current date.DATEDIFF(now(),d.tentative_date_of_return) <= now() + 3
You want 

AND d.tentative_date_of_return &lt;= CURDATE() + INTERVAL 3 DAY