6 Replies Latest reply on Jun 27, 2017 7:27 PM by gofmp15

    Script with Perform Find and based on calculation field

    jebber6685

      Title

      Script with Perform Find and based on calculation field

      Post

      I want to do what I thought would be a simple script, but I cannot figure out how to do it. 

      I have a set of records. Each record represents a specific project. 

      I want to be able to click a button and then all the records ( projects) that I have entered within the last 6 months from current date are found. 

      How can I create a find request that uses fields and calculations??

      It seem pretty simple

      find all records with creation date > Get(CurrentDate) - .5*365

      But I cannot enter this into the find request area within the script.

      How do I put this in a find request? In a script find request?

      Any help here would be greatly  appreciated.

      I have FMPro Advanced 12 v1
      OS - Windows Vista on desktop, Windows 7 on laptop