MySQL Forums
Forum List  »  General

Find Next payment Date
Posted by: simhadri raju
Date: December 10, 2018 07:30PM

I have below table with columns date and Number of Payments and Next Payment Date column is what i need to findout (expected output)

Every month payments will be done on 15th and 1st of every month so based on number of payments i have to findout the next payment date, So can you please help me with this requirement, I am New bee to Mysql.

Date |Number of Payments | Next Payment Date
2018-12-03 |2 | 2019-01-01
2018-09-30 |3 | 2018-11-01

Options: ReplyQuote

Written By
Find Next payment Date
December 10, 2018 07:30PM
December 10, 2018 09:44PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.