AnsweredAssumed Answered

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

Question asked by MichaelG on Sep 15, 2011
Latest reply on Sep 15, 2011 by 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

Outcomes