1 2 3 Previous Next 39 Replies Latest reply on Feb 15, 2014 6:32 PM by BrettWhistler

    Calculation to return most recent contact date for customer

    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.

        1 2 3 Previous Next