#Error in Future Date Field

Topic

New Reply

I have a calculated future date field that appears to work fine however on my new line I get the #Error message. How do I keep the #Error from appearing?

Reply | Quote

Replies

What is the expression you use to calculate the future date?

Reply | Quote

What is the expression you use to calculate the future date?

=DateSerial(Year([LastReviewDate]),Month([LastReviewDate])+12,Day([LastReviewDat
e]))

Reply | Quote

Try this instead:

=DateAdd(“yyyy”,1,[LastReviewDate])

or

=DateAdd(“m”,12,[LastReviewDate])

Reply | Quote