AnsweredAssumed Answered

Finding most recent data in a table

Question asked by truckerclock on Aug 31, 2009
Latest reply on Sep 2, 2009 by philmodjunk

Title

Finding most recent data in a table

Post

I have a field that is a calculation that uses Max to find the record with the most recent date and I want to do something similar with finding the username that made an entry most recently. The username is stored in the same table as the date I am retrieving and unfortunately for me Max does not work to find a username. I have a script that finds all records that have a Y for a certain field and then I also want to see the most recent contact date for that record which I am doing by using Max but I also want to see the username that made the contact. Thanks in advance. 

Outcomes