Return to FileMaker.com
If Then functon
I would like to performn the following function:
If a date field (membership joined date) is greater than 1/1/09, then enter the amount (number) from another field (membership donation amount) into a third field (total annual giving).
I don't know how to do this.
Calculation for total annual giving:
Case ( membership joined date > Date ( 1; 1; 2009 ); membership donation amount )
Retrieving data ...