2 Replies Latest reply on Sep 15, 2011 12:13 PM by MichaelG

    How to use most recent sale date for a given customer in a calculation?

    MichaelG

      Title

      How to use most recent sale date for a given customer in a calculation?

      Post

      Using the example of a Customers table and an Invoice table...

      I would like to have a "reminder" date field within the Customer's table for the date 6 months from the last sale to that customer.  The two tables would have a relationship based on the customer's ID.

      How would I setup of calculation in the "reminder" field to look in the Invoice table for the most recent invoice date for a given customer, and add six months to it?  (I do know how to add 6 months to a date)

      I would appreciate any guidance...

      Thank you,

      Michael