Increment a date field
I am new to Filemaker. I want to increment a date by 1 year. I have a field "Date Contract Expires". I want to use a button that performs a script that would increment the value in "Date Contract Expires" by 1 year.
Example: 01/25/2009 to 01/25/2010. I have done this in Micosoft Access but have not been able to do it in FileMaker.
Date Contract Expires = DateAdd("yyyy", 1, Date Contract Expires) is how it could be done in Access.