How to return max / latest date from a reference list

[Andre_van_Aarde]

I am wanting to create a virtual column in one of my tables where the value of the virtual column is the MAX of one of the columns in the reference list in the same table.

My Customers table has a reference list for calls made to the customer, I want to return the latest call date based on the timestamp field from the customer call table.

[dbaum]

Did you try something like the following for the virtual column's App formula property? If your Customers table includes a REFROWS column listing all the associated Customer Call IDs, you can dereference the list to transform it into a list of Call Dates from the Customter Calls table.

MAX([Customer Call IDs][Call Date])

[MultiTech]

Happy to see the select() statement wasn't suggested here 🙂

[Suvrutt_Gurjar · Accepted solution]

Please try 

INDEX( SORT( [Related Customer Calls][Call TimeStamp], TRUE) , 1)

Where [Related Customer Calls] is the system generated reverse reference column in the Customers Table.

[Selim_Tuncay]

I figured it out .thanks