Is there a way to autopopulate the expired date in a feature class?

Question

I have a table / feature class that has the due dates populated. Is there a way for the system to automatically populate a new column i have added named "status"? It should just look at the Due Date Column and compare it with the Current Date (Now()).

OwenEarley · Answer

Geodatabase Class Extensions can do this sort of thing but they require ArcObjects code to implement.

An example is the Timestamper Extension.

I would strongly suggest Xander's solution if the data is not time critical, as Class Extensions are powerful but a pain to implement.

Sheri_AnneSantos · Answer

Thanks for the too Xander. You are the smartest!!!

Sent from my iPhone

XanderBakker · Answer

I guess a python script as scheduled task (that runs each night) could do this job automatically.