Script to increment year by 1

[Bill_misc_IT]

I'm trying to write a script that will get the date from one field, add 1 to the year and set another field with this new date. It's for an expiration date.

When I simply perform a calculation of "date" + 365, it doesn't always work out (leap years, odd months, etc.)

Is there an easy way to accomplish this?

[comment]

Try:

Date ( Month ( StartDate ) ; Day ( StartDate ) ; Year ( StartDate ) + 1 )

This should return the same date a year from StartDate, with the exception of February 29 in a leap year which will return March 1 a year later.