find record updated within two weeks

Assuming youi have a field called DateField that contains the date you want to compare, this will do it.

  Enter Find Mode [ ]
  Insert Calculated Result [ Table::DateField; ">=" & Get(CurrentDate) -14 ]
  Perform Find [ ]

thank you, billmercer!

> Enter Find Mode [ ]
what should i find?

> Insert Calculated Result [ Table::DateField; ">=" & Get(CurrentDate) -14 ]
what should i set target field?

>Perform Find [ ]
what should i find? 1?

please let me know.

These are script steps. You don't specify the find, you let the script do it.

First you insert the Enter Find Mode step into a script.
Then the Insert Calculated Result,
and then the Perform Find.
Then you run the script to do the find.

The first step just puts FileMaker into Find mode.
The second step inserts the find criteria, which is the greater-than or equals operator, followed by a calculation that enters a date two weeks before today's date.
The third step actuall performs the find.

should i be like this?

http://www.angelakello.com/hiro/filemaker1.jpg

thank you, billmercer!

mhhh... still can't figure out...

after starting the script, it gets find mode...
what should i input in this case?

sorry... do you have any sample file?

The problem is there are two different script steps, one is called Perform Find, the other is called Perform Find/Replace.
The one you want is the Perform Find without the replace.

It's very unfortunate that FileMaker decided to give them such similar names, because they do completely different things.

thank you, billmercer!