3 Replies Latest reply: Mar 12, 2014 3:29 PM by Darrin Pilkington RSS

    Date range in set analysis with an 'or' option?

    Darrin Pilkington

      Hello,

      I have seen a lot of information on date ranges in set analysis but not quite one that could answer my question.

       

      I am trying to count SKUs for:

      ProductType = {1000,2000}

      AND

      StartDate <= vDate, EndDate > vDate

       

      OR

       

      ProductType = {1000,2000}

      AND

      StartDate <= vDate, len(EndDate) = 0

       

      I hope someone can help.  I have seen If statements nested in Set Analysis and I really don't want to go down that path.

       

      Thank you.