Adding years to a date

[rothdavid]

Hi:

Im stumped on adding 3 years to a date I have stored in a database. I used the model in the FMP 5 help file and it doesnt work for me at all.

Fields are : QualDate (Date Field) and the one I need to calc 3 additional years to is named QualDateExpires (which I made a calcuation field that should add 36 months to the date in field: QualDate and return the result into the Calc field: QualDateExpires.

From the example, I've tried this in the calc field:

Year(Date(Month(QualDate) + 36, Day(QualDate),Year(QualDate)))

I test using 1/1/2004 in the qual date and it returns 6-30-0006 ??

Can someone show me where I've gone wrong?

[Ugo DI LUCA]

Date(Month(YourDate),Day(YourDate),Year(YourDate)+3)

where Your Date is a date field and the result of this calc is formatte as date as well.