Dynamic Form Rules on Date Fields
I have a form with these three fields. Date received, Term Length and Term Date. I would like to set up rules so that the term date is calculated based on what Term Length is select. So if 30 days ...
Forum Discussion
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.
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.