Hey Jason - The way I'm reading this, it seems like John Jones SHOULD come up because he was sold in the last 90 days. If he didn't have the sold last week record, then he wouldn't come up because 6 months is AFTER 90 days.
I'm sorry but you're reading it incorrectly.
I want to have him -not- come up -because- he was sold in the last 90 days. This list is intended to be of people who -haven't- been sold in 6 months.
Found out how to do it. Didn't realize before that you can reference a smart list in a smart list. It's in the Special Filter area.
Create two smart lists. The first one is the list of people who match that have been sold in the last 90 days.
The second list is of people who aren't in the first list.