I want to bring up a list Omitting records categorized as "11.25", but only those within date range, "6/1/2018...6/30/2018"
How do I do this?
Note: all records in this table have a category number ranging from 1 - 15.
If you are doing this manually, you can do your broader search first (presumably the date range) and then run the Omit "11.25" step, but using Constrain instead of Perform Find. The difference is:
1. Perform Find will look at the whole table, regardless of the current found set
2. Constrain will look only at the current found set
(and not relevant to this question, but for the record, 3. Extend will look only at records outside of the current found set)
Of course, you can replicate the above process in a script if you want to.
Retrieving data ...