rothdavid Posted January 28, 2004 Share Posted January 28, 2004 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 More sharing options...
Ugo DI LUCA Posted January 28, 2004 Share Posted January 28, 2004 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now