Hello,
I have a field in a feature class that has an inspection date.
I have a second field in the same feature class called "status" that is either "pass / fail" or "expired"
I'd like the status column to auto populate each day based on the difference between the current date and the inspection date.
For instance, if the inspection date is more than a year old from the current date - the "status" field changes to "expired".
How would I accomplish this?
THANK YOU!
