1 Reply Latest reply on May 10, 2012 9:08 AM by philmodjunk

    Automatically update fields



      Automatically update fields


      Created a field called Archive where archive= If (Get (CurrentDate>InvDate);"Yes";GetCurrent(Date<InvDate);"No"
      insert the Archive field into layout. I made a change to the calculation be the Archive field will only update if I go back to every InvDate Field and reinsert the date back into the field.... I when I go to the record the date is already their... but the archive field will not update basic on the new calculation.... How do I update fields update automatically without re-enter the InvDate field information.. that is already their ?

      InvDate is define as Date Field
      Arcvhive is defined as a text field with a calculation

      [Edited by PhilModJunk to keep text from running off the edge of the screen...]