April 2, 200322 yr 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
April 2, 200322 yr Create your calculation field with a result of date and = to Date(Month(Date One), Day(Date One), Year(Date One)+1) HTH Lee
April 2, 200322 yr Author 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
April 2, 200322 yr 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
Create an account or sign in to comment