Creating a find script that produces next 7 days, next 30 days etc...
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.