Sample Header Ad - 728x90

How to select Overdue Rows with Date Frequencies?

0 votes
2 answers
605 views
+------------------------+--------+ | Invoice_id | due_date | amount | +-------------+----------+--------+ | 20 |2020-01-18| 1250 | +-------------+----------+--------+ | 21 |2020-01-15| 1335 | +-------------+----------+--------+ Get all Records with date passed n days and its multiple serires like below... for example n=5 SELECT * FROM invoices WHERE `due_date = DATE_ADD(CURDATE() + INTERVAL 5 days) OR due_date = DATE_ADD(CURDATE() + INTERVAL 10 days) OR due_date = DATE_ADD(CURDATE() + INTERVAL 15 days)` but i want to make it universal for any n value > **Note:** mySQL version in my machine is 5.*
Asked by Dev Matee (101 rep)
Jan 22, 2020, 04:37 AM
Last activity: Feb 5, 2025, 01:02 AM