Welcome to the Make community!
To do this, you can use these built-in functions:
-
map
map(complex array; key; [filter by key]; [csv-values for filtering]) -
sort
sort(array; [order]; [key]) -
last
last(array)
These functions may have also been covered in the Make Academy tutorials — refer to the Make Academy Course Overview to learn more.
Here’s an example of how you can use these functions together:
{{ last(sort(map(1.array; "start_date"))) }}
(Make Input Markup: Copy-paste the above into the field, including start/end curly brackets for it to import as intended)
e.g.:
Hope this helps! If you are still having trouble, please provide more details.
— @samliew