Field Calculate Most Recent Imagery Date for State Layer from Related Table of Flyover Events

Question

I have a layer of US States with a field for most recent date (of imagery collection) that I would like to field calculate from a (one to many) table with the imagery collection events, and the table will be related by state name initials.

I am a novice in arcade and python, so neither is better for me, but the eventual end result will be a scheduled process to run this update occasionally on a hosted feature layer, so I feel arcade is the better solution.

I see many posts doing similar things with arcade, but I am struggling to put them into action for my specific need.

Thanks in advance.

SeanT · Answer

For anyone interested, I got the recommendation to use the summary statistics tool for the max date from my table, then joined it to my feature layer and field calculated that way. Not the best long-term solution but solved my immediate need.