find record updated within two weeks

do you know how to create the script like that?
Hiroyuki TamuraField EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Hiroyuki TamuraField EngineerAuthor Commented:
thank you, billmercer!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.