Script with Perform Find and based on calculation field
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