Search for latest date in another table

Hi! I’m trying to figure out how get this expression.

There are two table, A and B
In table A I have information about some product.
In table B, which is ref table A, I have information about servicing product and date of that service
I want to search table B for latest date of service and get this date in table A
If someone get new row in table B with new date of service, it will be visible in table A

And another problem
I have this date and in another column I want to have this same date + 2 years.

I trying type [column with date] + [730] but it won’t work.

0 7 2,460
7 REPLIES 7
Top Labels in this Space