Perform find within date range, then omit by another criteria..help

[MR.Q]

I have written a script to perform find of records within a date range. I want to add to that: find and omit records (of found date range set) by status (another field). Any help for a rookie woudl be appreciated...

[Fitch]

Not sure what you're asking. You can either modify your original Find, or do a second find using Constrain Found Set.

[MR.Q]

Thanks If I have:

enter find mode

set field [table::date field;get (current date) &"..."& get(current date)+7]

Perform find

and want to add script which will omit records with "Cancelled" or "Declined" in the "Status" field. Do I add this before the perform find? Do I put both in the same calculated result?

Thanks.

[comment]

Try it this way:

Enter Find Mode []

Set Field [ table::date field ; Get (CurrentDate) &".."& Get (CurrentDate)+7 ]

New Record/Request

Set Field [ table::Status ; "Cancelled" ]

Omit Record

New Record/Request

Set Field [ table::Status ; "Declined" ]

Omit Record

Perform Find []

[MR.Q]

Thanks! That worked.