3 Replies Latest reply on Apr 21, 2011 9:15 AM by imgaryshap

    Omitting records in a script

    imgaryshap

      Title

      Omitting records in a script

      Post

      Hello, 

      I'm using FMP 8 on a Mac.   I'm trying to create a script for a simple sort, and am having trouble.

      I have two date fields.

      - DEAL OPEN

      - DEAL CLOSED

      I want a script that will list all records with open deals only, meaning that the Deal Open field has data in it, and the Deal Closed field is still blank.

      How do I do it?

      Thanks!