Hi All,
I have 2 tables. Table #1 contains the primary form. The table #2 tracks the status of those form as they are routed. I want to construct a third table linking the previous two, but the table #3 should only show the latest status based on the date of tab#2.
| Name |
ID |
| RefA |
aa1 |
| RefB |
aa2 |
| RefC |
aa3 |
| ID |
Status |
Date |
| aa1 |
Completed |
5/12/2023 |
| aa1 |
Pending |
5/9/2023 |
| aa1 |
Started |
5/1/2023 |
| aa2 |
Pending |
5/6/2023 |
| aa2 |
Started |
5/5/2023 |
| aa3 |
Removed |
5/10/2023 |
| aa3 |
Started |
5/1/2023 |
Result
| Name |
Status |
| RefA |
Completed |
| RefB |
Pending |
| RefC |
Removed |
I've tried ({$<%Date = {"$(=Date(Max(%Date), 'M/DD/YYYY'))"}>} Status)
