3 Replies Latest reply: Aug 8, 2011 11:39 AM by dkeresteci RSS

    Finding max Date given a criteria

      I have a list of dates and each of them is either TypeA or TypeB. I am trying to select the largest (or most recent) date from the list among only the TypeAs.

       

      So far I have been using Date(Max ([X_Date])) but I have not been able to figure out how to select based on a criteria.

       

      What I want is something like Date(Max ([X_Date]) where Category = {'TypeA'}).

       

      Any advice on how this can be achieved?