Hello,
I have understood there are several topic same as my topics.
I had read those articles, but I did not achieved what I want to do.
Table1 Flight master
FlightID | date
20240601 | 2024/06/04
20240620| 2024/06/20 (convert from 8digits text to serial number by text formula)
Table 2 Order
OrderID | FlightID
aaaaa | 20240601
bbbbb | 20240620
ccccc| 20240620
I would like to see the latest flight date.
In the table 2, there are many record which has same Flight ID.
I need to pick up all the records of latest date.
(both of bbbbbb and ccccc)
Please give your help.