Hi

How can I optimize this Perform Find in a Script:

Find Record Database:ate [= //]

It returns all records, which Date lays on Todays Date (//).

However how can I change it, so that it returns all records between Todays
Date and 7 days before Todays Date?

Thanks

Daniel

In article <slrndcnqkn.4j8.t-use (AT) ID-685 (DOT) user.individual.de>, Martin
Trautmann <t-use (AT) gmx (DOT) net> wrote:

Unless it's been fixed in FileMaker 7 (FINALLY!), there's a bug in the
Set Field command which means you can't use it with dates or times that
require anything other than a single date. Instead you have to use the
Insert Calculated Result (or whatever FileMaker 7 calls it).

Insert Calculated Result [DateField,
Status(CurrentDate) - 7 & "..." &
Status(CurrentDate)]

"Status(CurrentDate)" needs to be replaced with "Get(CurrentDate)" in
FileMaker 7.

The only problem is that the field DateField must be on the current
layout when the script is run. \



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Hi Harry

Thank you for your help!

It works perfectly.

/Daniel