4 Replies Latest reply: May 16, 2016 3:50 PM by Stefan Wühl

# Set Analysis Using Not Equal To a Date Range

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?

• ###### Re: Set Analysis Using Not Equal To a Date Range

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

• ###### Re: Set Analysis Using Not Equal To a Date Range

Or maybe

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

Excluding values in Set Analysis

• ###### Re: Set Analysis Using Not Equal To a Date Range

Stefan -

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

• ###### Re: Set Analysis Using Not Equal To a Date Range

It's the italic text beginning of 4th line