2 Replies Latest reply on Oct 27, 2010 8:49 AM by ChristineT.

    Calculation with Get(CurrentDate) updating every day

    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