AnsweredAssumed Answered

Script with Perform Find and based on calculation field

Question asked by jebber6685 on May 22, 2012
Latest reply on Jun 27, 2017 by gofmp15

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

Outcomes