AnsweredAssumed Answered

Calculating renewall (prolongation) date

Question asked by lijnbach on Jul 23, 2015
Latest reply on Jul 23, 2015 by lijnbach

Title

Calculating renewall (prolongation) date

Post

Hello everybody,

 

I have a date calculation, and I can’t figure out the best way to handle this. So what’s the problem?

 

I have a database with contracts. The contracts have a first period, an auto renewal period and a resignation period. But different for each contract. (The user has over 800 machines with a service contract, but all different contracts, with different renewal periods and resignation periods. The user wants to know every week when he has to do resignations)

 

e.g.

Starting first periode:                      01-01-2012

First periode:                                  12 months

Ending first periode:                       12-31-2012

 

Resignation:                                   3 months

Ultimate date for first resignation:  09-31-2012

 

First renewal (prolongation):          01-01-2013

Renewal period:                             6 months

Renewal end:                                06-30-2013

Ultimate date for resignation:        03-31-2013

 

Next renewal:    (In 2015)              This is the problem.

Next renewal end:

Ultimate dat for next resignation:   (It is all about this date for the user)

 

With older contracts there already has been a renewal for 5 or 10 times. In the example there already has been 5 automatic renewals after the first period.

 

I need a calculation that calculates the next renewal based on todays date.

 

I have a solution, but I don’t like my own solution. It is a script with a loop that keeps adding renewal periods until the appropriate date. But that means there has to be a complete recalculation each time the user loads a record or changes a record. And there has to be complete recalculation when the user prints a list with resignation dates for the coming week.

 

Anyone a better idea?

 

Thanks in advance,

 

Hans Lijnbach

 

 

Outcomes