MySQL Forums
Forum List  »  General

Re: Find Next payment Date
Posted by: Peter Brawley
Date: December 10, 2018 09:44PM


First work out the logic, then translate it to sql.

According to what you wrote, two factors logically determine the answer: (i) how many payments have been made and (ii) whether the 1st payment was > the 15th of the month and <= the 1st of the month. If you disagree, write a little logic to prove or disprove.

Then have a go at writing that in sql.

Options: ReplyQuote

Written By
December 10, 2018 07:30PM
Re: Find Next payment Date
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.