Caronte II Posted March 15, 2011 Share Posted March 15, 2011 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 Link to comment Share on other sites More sharing options...
comment Posted March 15, 2011 Share Posted March 15, 2011 Try = Date ( Month ( Datefield ) ; Day ( Datefield ) ; Year ( Datefield ) + NumberOfYears ) Link to comment Share on other sites More sharing options...
Caronte II Posted March 15, 2011 Author Share Posted March 15, 2011 Try = Date ( Month ( Datefield ) ; Day ( Datefield ) ; Year ( Datefield ) + NumberOfYears ) Thank you, it works beautifully, and it teaches me quite a bit. Best regards Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4346 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