concrete Posted April 2, 2003 Share Posted April 2, 2003 i need calculation field with a date as endresult and the new date should be the date in another field + 1 year example date1: 12/01/2003 result: 12/01/2004 Link to comment Share on other sites More sharing options...
Lee Smith Posted April 2, 2003 Share Posted April 2, 2003 Create your calculation field with a result of date and = to Date(Month(Date One), Day(Date One), Year(Date One)+1) HTH Lee Link to comment Share on other sites More sharing options...
concrete Posted April 2, 2003 Author Share Posted April 2, 2003 thx lee very simple I did stugle a little bid with the fact that month and day are oposite. because we write day month year, and date fields in filemaker work that way to, but the function is still month day year pieter Link to comment Share on other sites More sharing options...
Lee Smith Posted April 2, 2003 Share Posted April 2, 2003 Shoot, didn't look at your date structure, at least the calculation spelled out month, day and year. Here is another calculation that is even more simple. = Date One + 365 However, you can see that it would be off a day because of leap year. HTH Lee Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7860 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