In SAS Customer Intelligence Studio, incorrect counts are generated when you use the same range for different date-type fields (for example, day<=10 combined with month<=10) in a Select node.

When you view the audit log of the campaign, the counts that are returned for the September 10-October 7 range only return September records. For this example, the generated SQL code is similar to the following:

) <= 1.0 AND
( ( ( ( month( ( table0.Last_Expected_MC_Renewal_Date ) ) ) >= 9.0 AND ( month(
(
table0.Last_Expected_Renewal_Date ) ) ) <= 9.0) AND ( day( (
table0.Last_Expected_Renewal_Date ) ) ) <= 30.0) OR ( ( ( month( (
table0.Last_Expected_Renewal_Date ) ) ) <= 10.0 AND ( day( (
table0.Last_Expected_Renewal_Date ) ) ) >= 1.0) AND ( day( (
table0.Last_Expected_Renewal_Date ) ) ) <= 7.0) ) AND
( day( ( table0.Last_Expected_Renewal_Date ) ) ) >= 10.0
) table3 ;

In this code, the comparison operator (<=) does not take into account the different date-type fields.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Marketing Automation 6.4 is available at:

A fix for this issue for SAS Marketing Automation 6.3 is available at: