Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

find record updated within two weeks

do you know how to create the script like that?
0
Hiroyuki Tamura
Asked:
Hiroyuki Tamura
  • 5
  • 4
1 Solution
 
billmercerCommented:
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 [ ]
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
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.
0
 
billmercerCommented:
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.

0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Hiroyuki TamuraField EngineerAuthor Commented:
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
thank you, billmercer!

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

after starting the script, it gets find mode...
what should i input in this case?
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
sorry... do you have any sample file?
0
 
billmercerCommented:
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.
0
 
billmercerCommented:
Also, you will want to uncheck the option to Pause on the Enter Find Mode script. See this example...
http://www.milleniumhandandshrimp.com/upload/two%20weeks.fp7

This is just a simple example, you will want to add more to the script to do things like switch to the correct layout, and possibly allow the date range to be modified.
0
 
Hiroyuki TamuraField EngineerAuthor Commented:
thank you, billmercer!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now