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()).
I guess a python script as scheduled task (that runs each night) could do this job automatically.
Thanks for the too Xander. You are the smartest!!!
Sent from my iPhone
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.