guermo

Data symbolized on a date difference calculation?

Discussion created by guermo on Jan 21, 2014
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!

Outcomes