Perform Find using Field

[PerryL7]

Hi all,

I am having an issue using the perform find function in the scriptmaker. I cannot figure out how to use a table field or a variable for the parameter in the find:

(i.e., RecruitInfo.StartDate >= RecruitInfo.GlobalStartDate or RecruitInfo.StartDate >= $StartVariable)

I can only see how to enter a fixed value. Does anyone know how to use the find function with variables or table fields? Thank you.

[Ender]

Use

Enter Find Mode []

Set Field [ RecruitInfo.StartDate ; ">=" & RecruitInfo.GlobalStartDate ]

Perform Find []

or

Enter Find Mode []

Set Field [ RecruitInfo.StartDate ; ">=" & $StartVariable ]

Perform Find []

[PerryL7]

Thanks for the help Ender. That worked.

-PerryL7

[doostin]

I have a similiar question. How do I perform multiple finds? I have a database with 4 different date fields that are all related date fields. I want to perform a find in the date fields with the current month but with any year. The catch is that not all records have all date fields filled in, so I need to do multiple finds, in the same find, I guess that would be an AND in boolean terms. With the Set Field method that only allows to do one search in the same found set.

This is how I am doing the find:

Month ( Get ( CurrentDate ) ) & "/*/*"

Any ideas?

Dustin

[doostin]

Nevermind!

I figured it out, here is what I did, if there is another way to do it, please let me know.

Enter Find Mode[]

Set Field [KNC:: Child1 Birthday; Month ( Get ( CurrentDate ) ) & "/*/*"]

New Record/Request

Set Field [KNC:: Child2 Birthday; Month ( Get ( CurrentDate ) ) & "/*/*"]

New Record/Request

...

Perform Find[]

Thanks!

Dustin