function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Kent ManningKent Manning 

How to retreive all records in a related list.

I have a field on the case object that looks up, via the asset, the extended service contract end date.  My problem is that it is only returning one entry from the contract related list and hence returning the wrong end date.  Does anyone know how to make the lookup query the related list for the most recent acitive contract?

 

My lookup formula is this:

Asset_num__r.Contract__r.EndDate