I don't see why you need a script for this.
In Manage Database FIelds, you can double click the field definition for status to bring up it's field options. Click the auto-enter tab and select the by calculation option to enter this expression:
Case ( Months = 0 ; "Current" ; Months > 0 ; "Ahead" ; "Behind" )
You'll probably also need to clear the "do not replace existing value..." check box.
Thanks, that did it! It seems so simple, but I'm simply clueless! :)
I dont see how this is going to matter if you are using a Get ( CurrentDate ) for your months calculation. The auto-enter wouldn't update at all unless your calculation references a static field that that field value is updated. Perhaps you can explain how the "Months" calculation field is derived.