Trouble with Find Criteria

[Dudley Dufort]

I have a script that finds "late pays" in a club database. In the “perform find” script step, the find criteria are; find “2007” in the “history” table/ “year” field AND omit “2008” in the same field. That works fine. I wind up with members that were active in 2007 but not in 2008.

What I’d like to do is replace those specifically entered years with a “get” function. (Year(Get ( CurrentDate )))-1 and (Year(Get ( CurrentDate )))

How do I enter a calculation or get function in the find criteria dialog box to automatically find the prior year and omit the current year?

Dudley

[_henry_]

Hi Dudley,

Could you save first your "get" function or calculation on a $Variable. Then, do the "Perform Find" on that $Variable result?

[comment]

See if this helps:

http://www.fmforums.com/forum/showpost.php?post/280414/

[Dudley Dufort]

Yes but . .

There's no provision for multiple find criteria. I tried that "set field" routine in conjunction with another "set field" "constrain found set" request but couldn't get "constrain" to work as expected.

Dudley

[comment]

I don't see why you would need to constrain a found set in the context of a single find operation. Try something like this:

Enter Find Mode [ ]

Set Field [ History::Year ; Year ( Get (CurrentDate) - 1 ) ]

New Request

Set Field [ History::Year ; Year ( Get (CurrentDate) ) ]

Omit Record

Perform Find [ ]

[Dudley Dufort]

That's perfect. Thanks!! That's exactly what I was trying to accomplish. I was using the wrong script steps and/or in the wrong sequence.

Thanks again, Dudley