Menu
Hello,
I want to select data from my databse where date + 7 has to be shown, if date + 7 days is passed current day(real world) it should not show..
This is my code for now but I’m not sure it does what I need.
sqlQuery = “SELECT * FROM placed_orders WHERE delivery_date BETWEEN DATE_SUB(CURDATE(),INTERVAL 7 DAY) AND CURDATE() OR delivery_date=’1989-01-01′ GROUP BY ob_no ORDER BY order_date DESC”
Thanks in advance !