Lookup Record Pull Current Date From Another Table

Brandon_Leavitt · May 4, 2024, 5:45pm

Hello,

I am using the LookupOne formula, but I need to know how to change this code to pull in the most current date.

Communication.lookupOne(ID2=$ID2).Date_Added

BiBo · May 4, 2024, 8:26pm

For all Date_Added
MAX(Communication.all.Date_Added)

BiBo · May 4, 2024, 8:34pm

Last Date_Added for linked rows
MAX(list(Communication.lookupRecords(LinkedColumn=$id).Date_Added))

Brandon_Leavitt · May 4, 2024, 10:45pm

Hello,

Thank you, This worked.
MAX(list(Communication.lookupRecords(ID2=$ID2).Date_Added))