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

    Dates in Set Analysis issue

    Nadezhda Brusova


      I faced a problem with dates comparison in set analysis.

      Here's an expression:

      Count(distinct {<





      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