Calculation with Get(CurrentDate) updating every day
I have a calculation set up so that if the user enters "YES" into a field (Field1), the calculation field (CalcField) will automatically display the current date:
CalcField= If ( Field1="YES" ; Get (CurrentDate))
What I need it to do is insert the current date when the user enters YES and then leave it there. Right now the calculation is reevaluating every day, so that no matter when the user entered YES, the date displayed is the current date. The point is to record what date the user typed YES into the field.
Thanks in advance!!