Return to FileMaker.com
I have two fields, one with a date and one with the month.
I want the third field be the calculation sum of the date and months from the above two fields. How can I achieve that?
eg field 1= 02/3/2016
field 2= 25
i want field 3 to be = 03/3/2018
Date ( Month ( field1 ) + field2 ; Day ( field1 ); Year ( field1 ) )
FileMaker will handle the corrections for leap years and days, too!
Retrieving data ...