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

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.

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?

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

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

2 Likes

IT WORKED! Many thank yous Happy New Year

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

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

2 Likes