I am developing a Lease Information Management System.
This system is related with Land rent Contracts. Every contract have a Begining date and Expiry date.
For example Begingin Date is: 01-08-06
And Expiry Date is : 31-07-16
I have store these 2 dates in DB.
Payment will be given to the owner of the land evey year in advance.
Now I have to calculate the year ranges for these two dates (for example year 1 = 01-08-06 to 31-07-07 )
Now there are 10 years in this example.
First of all i have to obtain all the duration from these beging and expiry dates. For 10 years if payment is yearly then I need to calculate 10 ranges for each year.
Second , If payment is due in month of october 09 then its show that payment is due before 45 days, because payment processing time is 45 days appeximately. beacuase if payment got late it will cost .