Hello,

I'm a new user of FM and not an English speaker... so please be patient with me TIA.

I have a DATE field which is the beginning date of lease. ex :01/01/2000

Then two fields where I enter a numeric value representing:

First lease period in number of years: ex : 5

Second lease period in number of years: ex : 5

I would like to create a new field that calculate the end

date of the leasing. In this example it should be: 01/01/2010

(no need to take into account years of 365 days)

I do not know how to write the fonctions.

Can anyone help

Thank you

Caronte II

Try =

Date ( Month ( Datefield ) ; Day ( Datefield ) ; Year ( Datefield ) + NumberOfYears )

Try =

Date ( Month ( Datefield ) ; Day ( Datefield ) ; Year ( Datefield ) + NumberOfYears )

Thank you, it works beautifully, and it teaches me quite a bit.

Best regards