Do you need this value stored on the customer record or just there for display when on the customer record, because you could just put that search as the value of the field with a MAX of date like suggested above.