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

    Set Analysis Using Not Equal To a Date Range

    Ruth Hopkins

      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?