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


      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}


      StartDate <= vDate, EndDate > vDate




      ProductType = {1000,2000}


      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.