Capture the value of the date column, of the last record, according to the id

I have my payment records that are stored in a table, which have the following columns; id, amount, date

I need to capture the value of the date of the last entered record, in a column of another table, according to the id.

LOOKUP(
  MAXROW( payments-table , "_RowNumber" ) ,
  payments-table ,
  key-column ,
  date
)

No idea what this part is supposed to mean.

2 Likes

Thank you so much.

1 Like