2 Replies Latest reply: Jun 12, 2009 3:41 AM by Amirali Vastani RSS

    Set Analysis Multiple Range Search

    Amirali Vastani

      I saw a post on set analysis with range search posting the answer as

       

      SUM({$<MOTRenewal={">$(=Today())<=$(=(Date(Today()+14)))"}>} FieldToAggregate))


      My question is what if I have multiple date ranges that are not continuous. Do I just use a comma to separate and add the other ranges or do I have to do a + SUM() with the other ranges?

      thanks in advance