11 Replies Latest reply on Feb 10, 2016 12:24 PM by Shinichiro Murakami

    Multiple conditions using dates

    xiaoxiao.ma

      I've been struggling with this one... The goal is to label Categories that contain all 3 Sub-Categories (a, b, c) that happen within a 5 day range 1 else 0. My approach has been to find the max of all min dates for sub-cat, then the min of all max dates for sub-cat, and compute the datediff within the category level. Is there a better way to go about this problem?

       

      Thanks in advance!