Set Analysis Using Not Equal To a Date Range

[#1]

I am trying to count a list of claims where the assignment date is within a variable range, the creation date is before the begin date of the variable range, and the reopen date is not within the variable range.  There may not be a reopen date.  It appears if there is not one the field value is set to a -.  I have tried both of these and get a null set:

Count({<
ClaimAssignmentDate={">=$(=vBeginDate)<=$(=vEndDate)"},
ClaimCreateDate={"<=$(=vBeginDate)"},
ClaimReOpenDate=ClaimReopenDate-{">=$(=vBeginDate)<=$(=vEndDate)"}
>} ClaimID)

And

Count({<
ClaimAssignmentDate={">=$(=vBeginDate)<=$(=vEndDate)"},
ClaimCreateDate={"<=$(=vBeginDate)"},
ClaimReOpenDate-={">=$(=vBeginDate)<=$(=vEndDate)"}
>} ClaimID)

Can anyone figure out what I am doing wrong?

[sunny_talwar]

What about this:

Count({<
ClaimAssignmentDate = {">=$(=vBeginDate)<=$(=vEndDate)"},
ClaimCreateDate = {"<=$(=vBeginDate)"},
ClaimReOpenDate = e({<ClaimReopenDate = {">=$(=vBeginDate)<=$(=vEndDate)"}>})
>} ClaimID)

[swuehl]

Or maybe

Count({<
ClaimAssignmentDate={">=$(=vBeginDate)<=$(=vEndDate)"},
ClaimCreateDate={"<=$(=vBeginDate)"},
ClaimID = e({<ClaimReopenDate = {">=$(=vBeginDate)<=$(=vEndDate)"}>})
>} ClaimID)

Excluding values in Set Analysis

[sunny_talwar]

Stefan -

I think you need to highlight what you have done differently, I spent 2 minutes figuring out what exactly was different

[swuehl]

It's the italic text beginning of 4th line