I have an arcade expression symbolizing a feature (valve) and related table (valve inspection) join.
I created an arcade expression to symbolize on the map based on inspection date being within 14 months of today:
IIF(DateDiff(now(), $feature.InspectionDate, 'months') < 14, "Last Inspection Within 14 Months", "Last Inspection > 14 Months")
Works great, except it's symbolizing all the records (thousands of them) from the previous years.
Is there additional expressions I can include to only look at the most recent inspection date, and determine if that is within 14 months of "now"?