Range from start and end date and find date in this range

[ayesha789]

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 .

[ayesha789]

Dear Sir

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-01-05

And Expiry Date is : 31-12-06
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.

I can calculate number of years using year(Begining Date ) - year( Expiry Date)

For Year 1 ending Date I can add Beging Date + Interval 1 year

For Year 2 Beging I can add Year1 Endind Date + interval 1 day

For Year 2 ending date I can add year 1 Beginging + interval 1year

But if number of years are more it seems difficult.

I want Result like

Years          Beginging Date                  Expiry Date

Year1         01-01-05                              31-12-05

Year2         01-01-06                              31-12-06

Year3         01-01-07                              31-12-07

Year4         01-01-08                              31-12-08

Year5         01-01-09                              31-12-09

I need dynamic way of calculating and showing becuase for every contract nuumber of years change.

[ayesha789]

Please help me....

[ayesha789]

please help me...