AnsweredAssumed Answered

Creating a find script that produces next 7 days, next 30 days etc...

Question asked by BrettWhistler on Feb 7, 2014
Latest reply on Feb 11, 2014 by BrettWhistler

Title

Creating a find script that produces next 7 days, next 30 days etc...

Post

     I have a solution with several tables in it.  I'm trying to make a script that will find records with a certain date in one of my fields. The field name is "Next Follow Up" and is a date field.  The table is "Customers."  I produced a script based on this support post...http://help.filemaker.com/app/answers/detail/a_id/5913/kw/finding%20a%20date%20range.

     Here is the script I came up with:

     Enter Find Mode []

     Insert Calculated Result [Select; Customers::Next Follow Up[( Get ( CurrentDate )  +  7  &  "..."  & Get ( CurrentDate) )]]

     Perform Find []

      

     When I perform the find I receive an error message: "The provided find criteria is not valid.  Enter a valid request before proceeding."

      

     Any help on what I need to do to modify this would be greatly appreciated.

      

Outcomes