Database Reference
In-Depth Information
Do include the quote marks, but don't include the period at the end. You're typing the
proper search criteria into the variable's value box, just as you'd type into a date field.
That is, you're telling FileMaker that the date value is “greater than or equal to today,
minus 7 days.”
6.
Move the
Perform Find
script step into the current steps list
.
Now it's time to tell FileMaker how to use the date you've just defined.
7.
Select “Specify find requests.” Click Specify and then click the Specify Find
Request window's New button
.
The Edit Find Request window appears. You know it well by now.
8.
In the “Find records when” list, choose the Invoices::Date Due field
.
That says which field to search.
9.
In the Criteria box, type
$theDate
.
FileMaker will use the dynamic date value to search each time the script is run.
10.
Click the Add button, check your window against
Figure 12-16
and then click
OK twice
.
You're back in the Edit Script window.
11.
Save the script and then close the Edit Script window
.
Attach your script to a button on the Invoices layout and test your new button.
