5 Replies Latest reply: Jul 28, 2014 1:15 PM by Steve Zagzebski RSS

    Get min date over a group of fields

    Steve Zagzebski

      I haven't be been able to find a discussion to exactly match my issue.

       

      I want to retrieve ONLY the record with a minimum date over a the group fields (ID, User) from a table that I have loaded. The sample is:

       

      IDUserTimestamp
      1ZAG01/01/2014
      2KUH04/01/2014
      1OWE03/01/2014
      2LUE02/01/2014
      3LAN05/01/2014

       

      The result would be:

      IDUserTimestamp (min)
      1ZAG01/01/2014
      2LUE02/01/2014
      3LAN05/01/2014