7 Replies Latest reply: Nov 1, 2017 9:12 AM by Sunny Talwar RSS

    Dates in Set Analysis issue

    Nadezhda Brusova

      Hi

      I faced a problem with dates comparison in set analysis.

      Here's an expression:

      Count(distinct {<

      verificationDate={"<=$(date(TDLink))"},

      verificationDate={">=$(date(FDLink))"},

      verificationStatus={'Valid'}>}ExtIDDevice)

       

      and this expression doesn't work cause there are two rows to be excluded from the given result. I need verificationDate to be between FDLink and TDLink but I can't get it working.

      Comparing FDLink and TDLink with now() gives the expected result.

      Count has to be 208 for Nov 2017