Date not working in set analysis.

[Rajat1]

So I have written an expression, First part of date is showing correct but other part is not getting calculated.

=count(distinct{(< customer_key=p ({<order_processing_date_plan_acv_link={"$(= '>='& date(MonthStart(min(order_processing_date_plan_acv_link),-2))) & '<=' & date(MonthStart(min(order_processing_date_plan_acv_link),-1))))"}>})>

-(< customer_key=p ({<order_processing_date_plan_acv_link={"$(= '>='& date(MonthStart(min(order_processing_date_plan_acv_link),-2))) & '<' & date(MonthStart(min(order_processing_date_plan_acv_link),-1))))"}>})>
*
< customer_key=p ({<order_processing_date_plan_acv_link={"$(= '>='& date(MonthStart(min(order_processing_date_plan_acv_link),-1))) & '<=' & date(MonthStart(min(order_processing_date_plan_acv_link))))"}>})>))
* < customer_key=p ({<order_processing_date_plan_acv_link={"$(= '>='& date(MonthStart(min(order_processing_date_plan_acv_link)))) & '<=' & date(MonthEnd(min(order_processing_date_plan_acv_link))))"}>})>
} customer_key)

Attaching the screenshot of output for the above expression please let me know how get date after '&' , its not getting calculated.

Thanks,

Rajat.

[marcus_sommer]

The syntax isn't right - it should be rather look like (simplified):

count({< Date = {">=$(=min(Date))<=$(=max(Date))"}>} Key)