4 Replies Latest reply: Sep 25, 2018 9:40 AM by Selva A RSS

    AND Condition for Same  date fields

    Selva A

      Hi ,


      I want to get the lessthan 24 months and greater than 12 months data using set expression.


      This is my set expression.



      COUNT({($<id]={'17'},[DATE]={"<=$(AddMonths(ADMISSION_DATE,24), 'MM-DD-YYYY')"},[DATE]={">=$(AddMonths(ADMISSION_DATE,12), 'MM-DD-YYYY')"} >)} [Name])



      Is it correct ?