I am sure this is so basic, but it is giving me fits. I am trying to set a up a field to autofill data based upon a date. I have a field "Status" that has a value list of "Inactive, Current, Past Due, Updated Ad" I am trying to make the field display "Inactive" if the field "Date Terminated" is less than the current date. I want to be able to override this autofill if needed. I can't seem to get the formula right to do this. I have zero experience in creating formulas. Any help would be greatly appreciated. Thanks. :(

If I read your post correctly, you'll want 2 status fields:

One you can enter data into

One that calculates

The one that calcs will display on the layout, but if you click on it, a script will place the cursor in the one that accepts data (that is right underneath the display field in your layout).

make this the calc for your display status field:

case( Get ( CurrentDate ) > fieldTerminated ; fieldEnterStatus ; "Inactive")

then, if you have in the entry status field and the Terminated field is not set earlier than today, the display status field will show what you entered (or nothing if you've entered nothing).

But if the termination date is earlier than today, the display status will say "inactive" no matter what you've entered in the other status field.

Clear as mud?

Don

Took a little tweaking, but that got it done. Thanks so much.