Date Variables with Set Analysis

[cbaqir]

Can someone please help me get this in the right syntax?

=count({$<DETECT_DATE= {"<=$(vDefectStart) and >=$(vDefectEnd)"}*e( {1< PRIMARY_DECISION_BODY ={'SMG Committee'}) >}distinct DEFECT_ID)

[NZFei]

For this sort of things , you can achieve by several ways. Attached is another way and it is useful sometimes.