I have a given date:
2013-12-20
This is an issue date of a product where the product expiries in 6 months from the date of issue. The expiration date it is not stored so I want to check from the given issue date if it is expiring in the next month of now().
So my guess would be to add 6 months to the issue date and check now + interval of 1 month if it is expiring?
Here is what I tried:
SELECT * FROM `products` WHERE DATE_ADD(`issue_date`,INTERVAL 6 MONTH)
< DATE(NOW() + INTERVAL 1 MONTH) ORDER BY `issue_date` ASC
What I'm I doing wrong?