Dynamic Form Rules on Date Fields

Any ideas?

Use a formula and then if the data entry field is blank, use the form rule to populate the data entry field, but by being a data entry field you an override if necessary.

Okay, my only issue with using a formula is that one of the options is other.  So if they select other, I would like them to be able to enter the date.  How can I do that in a formula?  Here is what I currently have.

If([Term Length]= "30", [Date Received]+Days(29),
    [Term Length]= "60", [Date Received]+Days(59),
    [Term Length]= "90", [Date Received]+Days(89),
    [Term Length]="120", [Date Received]+Days(119),
    [Term Length]="Immediate",[Date Received])

The term date field is a read only since it is a formula but I need it to be editable if Term Length is Other.  I'm hoping not to have to use two fields for this.

You will never be able to edit a formula field.  I'm suggesting to have a formula field and have the form rule copy the value from the formula field into the data entry field when the data entry field is blank.  That was it will be automatic, but still editable.

That makes sense but it's not working.  I have the term date formula and it's calculating correctly.  I have the form rule set to when term length is not equal to other, change term date to the value in the term date formula.  Don't know why it wouldn't update.

Can you edit that form rule and observe the checkbox at the very very bottom. Uncheck it. That will Force the rule to always fire.

Wait, it is working.  The problem is getting it to fire when the term length is changed from one to another.  So lets say the user selected 30 but meant to select 90.  It doesn't change the date in the term date.

See my post above

Thanks, that did it.