Can someone help me with the right syntax to get the intersection of these expressions? I am trying to get the counts of DEFECT_ID where the DETECT_DATE >= AddMonths(Today(),-12) AND where the CLOSE_DATE >= AddMonths(Today(),-3).
Count({$<DEFECT_ID *= {"=Min({1}DETECT_DATE) >= AddMonths(Today(),-12)"}>}DISTINCT DEFECT_ID)
Count({$<DEFECT_ID *= {"=Min({1}CLOSE_DATE) >= AddMonths(Today(),-3)"}>}DISTINCT DEFECT_ID)
