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
Last activity: Feb 5, 2025, 01:02 AM