Jump to content

Adding years to a date


This topic is 7365 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

This topic is 7365 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.