AnsweredAssumed Answered

Increment a date field

Question asked by gem2376 on Jan 7, 2010
Latest reply on Oct 23, 2015 by AjEGfmTech


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.