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 SELECT DISTINCT    
d.name AS "ID:Link/Demo Request:120",    
d.requester_name AS "Requester Name:Data:190",    
d.customer_name AS "Customer Name:Data:250",    
d.date_of_request AS "Date Of Request:Date:120",    
d.tentative_date_of_return AS "Tentative Date Of Return:Date:170",    
d.material_sent_from_location AS "Material Sent From Location:Data:190",    
d.delivery_note AS "Delivery Note:Data:100",    
d.material_status AS "Material Status:Data:120",    
d.product_supplied_condition AS "Product Supplied Condition:Data:150",    
d.courier_service AS "Courier Service:Data:120",    
d.shipped_date_from_rahi AS "Shipped Date From Rahi:Date:120",    
d.tracking_no AS "Tracking No:Data:120",    
DATEDIFF(now(),d.tentative_date_of_return) AS "No Of Days:Data:100"

FROM    
`tabDemo Request` as d

WHERE    
d.material_status not like "Recieved From Customer"    
AND    
DATEDIFF(now(),d.tentative_date_of_return) &lt;= now() + 3

ORDER BY d.tentative_date_of_return ASC
You want 

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