6 Replies Latest reply: Jul 24, 2012 1:19 PM by mayilvahanan ramasamy RSS

    date comparison in set analysis

      I am looking to compare 2 date fields using set analysis. 

      Date1 <= Date2 + 29 

      In this example I am trying to make sure that Date1 is less than or equal to Date2 + 29 days.

       

      My current expression is:

      COUNT({<Field1={A], Field2={B} >} Products)

      Now I just need to incorporate the date comparison into the above expression.

       

      Thanks!