AnsweredAssumed Answered

Increment a date field

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

Title

Increment a date field

Post

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.

Thanks

 

Outcomes