AnsweredAssumed Answered

Calculation to return most recent contact date for customer

Question asked by BrettWhistler on Feb 13, 2014
Latest reply on Feb 15, 2014 by BrettWhistler

Title

Calculation to return most recent contact date for customer

Post

     I'm attempting to design a contact management solution.  Most of it is coming together.  The basis is each customer has multiple contact dates (with related notes) in customer and contact tables.  I want to develop a calculation field that will determine when the last contact I made with a customer was.

     I found the Get (NthRecord) and thought I could make that work.  The calculation resulted in the earliest date in my contacts table...and it wasn't related to the proper customer.

     Any help would be greatly appreciated.

Outcomes