2 Replies Latest reply on Oct 23, 2015 4:23 PM by AjEGfmTech

    Increment a date field



      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.