AnsweredAssumed Answered

Calculation with Get(CurrentDate) updating every day

Question asked by ChristineT. on Oct 26, 2010
Latest reply on Oct 27, 2010 by ChristineT.

Title

Calculation with Get(CurrentDate) updating every day

Your post

Hello,

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!!

CT

Outcomes