9 Replies Latest reply on Feb 11, 2014 4:43 PM by BrettWhistler

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

    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.