AnsweredAssumed Answered

Date calculation

Question asked by LynnRogers on Sep 14, 2013
Latest reply on Sep 16, 2013 by philmodjunk


Date calculation


     Hi everybody

     I need some help on a date calculation script. I am using Filemaker Pro 12 Advance and I need a script that will take the date that is in a "creation Date" field in my PM Table and add the service frequency field in my equipment table (which is a number field representing the number of days before the next service) and put the results in my "Due Date" field in my equipment table. example

            PM Table                                    Equipment Table                             Equipment Table

     Creation Date  Field                  Service Frequency Field                         Due Date Field

            9/14/2013                 +          30 (Days) number will very         =           10/14/2013

     Any help will be greatly appreciated