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...]