Hi

I am having a find and scripting problem. I know this should be easy but I can't get it to work...

I have a job file and each job has a deadline date. The script I have setup is searching for all jobs within a certain date range which is working fine but I then want to omit or constrain these found records so that any COMPLETED jobs are not shown. The first part of the script works fine - all the jobs within the date range come up. Then the second part of the script when i perform either another Perform Find using the omit variable or I try to use the constrain found set it then shows all records with all dates except the COMPLETED jobs!! I can't get this to work and it's driving me nuts as I know it should be simple - please help!!!!

I am searching for the date range using:

Enter Find Mode

Set Field (date range)

Perform find

Do I then need to go into find mode again or do I use constraind found set and set up Omit Records variables?

Cheers

Rich

Fill out both fields when and-searching, while you need several request when or-searching.

The opposite is when you stack a series of omitted requests (DeMorgan), make the find - and issue a "Show Omitted Only" in the end.

Constrain Found Set is yet another option, then it goes like:

Enter Find Mode

Set Field (date range)

Perform find

Enter Find Mode

Set Field (completed)

Constrain Found Set

Just remember that people got away with your kind of searches, way before the feature popped up in fm6!

--sd