Link to home
Start Free TrialLog in
Avatar of Hiroyuki Tamura
Hiroyuki TamuraFlag for United States of America

asked on

find record updated within two weeks

do you know how to create the script like that?
Avatar of billmercer
billmercer

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 [ ]
Avatar of Hiroyuki Tamura

ASKER

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.

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.
ASKER CERTIFIED SOLUTION
Avatar of billmercer
billmercer

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thank you, billmercer!