Is it possible to pull the latest date from a related virtual column

[Arizno]

I have a “Related meetings” virtual column in my table. I want to pull the latest meeting date from the column. Is that possible? I do not need any other info just the latest date.

[TyAlevizos]

Is your “related meetings” column of type list and referring to a second table with a calc like REF_ROWS() or similar? Or, is it something else, i.e. what is the data type for this column?

[Arizno]

Yes is it is a ref row and it’s a date time data type.

[Bahbus · Accepted solution]

Try INDEX(SORT([Related Meetings][Meeting Date]), 1) subbing in your column’s names.

[Arizno]

Bahbus:

INDEX(SORT([Related Meetings][Meeting Date]), 1)

IT WORKED! Many thank yous Happy New Year

[Arizno]

One question, the date time shows the seconds. Is there a way to remove them easily.

[Aleksi]

You can find an option under the column’s definition. It’s called “Ignore seconds”.