Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi,
Now it works. Thanks alot..