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 ?

       

      Thanks,

      Selva