Expression Correction

[#1]

  Hi,

I am trying find the count of customers who shipped 2 months prior to their due date and here is the expression am using but it just shows blank.please let me know if I am doing something wrong in the expression.

=count({<Date(Shipping_Date,'YYYYMM') = {">=$(=Date(AddMonths(Customer_Due_Date1,-2),'YYYYMM') <=$(=Date(Customer_Due_Date1,'YYYYMM'))"}>}
distinct Customer_Key)

Thanks,

Swetha

[#2]

I do not think you can use an expression in the first section of set analysis.

Try doing

Date(Shipping_Date,'YYYYMM')

in the script as a new field, then using the new field there instead

[#3]

Thank You for the reply.

I did replace the first part of the expression with a filed but still does not give the reult.I thibnk something is wrong with

{">=$(=Date(AddMonths(Customer_Due_Date1,-2),'YYYYMM') <=$(=Date(Customer_Due_Date1,'YYYYMM'))"}>}

because when I replace the above value with some year and number the expression gives the result.

Thanks,

Swetha

[#4]

Thank You for the reply.

I did replace the first part of the expression with a filed but still does not give the reult.I thibnk something is wrong with

{">=$(=Date(AddMonths(Customer_Due_Date1,-2),'YYYYMM') <=$(=Date(Customer_Due_Date1,'YYYYMM'))"}>}

because when I replace the above value with some year and number the expression gives the result.

Thanks,

Swetha