Date > xx/xx/xxxx OR Null - a way to combine?

Is there a way to use an OR using the connector that can handle a DATE or a Null?

Example (these are fields in one of our custom objects):

Deal Status = Cashout OR Open (using Deal Status equals Cashout, Open)

AND

Deal Cashout Date > 12/31/2006 OR null

I can get this in two queries, but want to combine in to one.

The query really boils down to:

(Deal Status = Cashout and Cashout Date > 12/31/2005) OR (Deal Status = Open and Cashout Date = null)

Any ideas are appreciated. Jonathan

Need an account? Sign Up

Have an account? Sign In