date calculation

[concrete]

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

[Lee Smith]

Create your calculation field with a result of date and = to

Date(Month(Date One), Day(Date One), Year(Date One)+1)

HTH

Lee

[concrete]

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

[Lee Smith]

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