AnsweredAssumed Answered

Display the most recent date in a field

Question asked by jackmac on Sep 14, 2015
Latest reply on Sep 14, 2015 by erolst

Hi all,


I have a field which is called 'DatePaidTo' in my 'Invoice' table and it is effectively the most recent date an invoice has been paid. A customer will pay monthly and his invoice record will show customer ABC paid up until the end of the month.


When I show the 'DatePaidTo' field on his record it only finds the first record. I want the field to display the most recent entry. I'm assuming I can use Conditional Formatting but a unable to find a formula. Any suggestions please?


I'm using FM Pro 14