Return to FileMaker.com
Trying to write a script that will find record based on the following calculation. Little lost in how to construct this.
Get (CurrentDate) - CONTRACTS::date_award ≥ 90 and IsEmpty ( CONTRACTS::form_1201 )
Enter Find ModeSet Field [Contracts::date_award ; "< " & get ( CurrentDate ) -90]Set Field [Contracts::form_1201 ; "="]Set Error capture [on]Perform Find 
Retrieving data ...