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...]
There are some syntax errors in the function you posted. Is this what you have?
If (Get (CurrentDate ) >InvDate);"Yes"; "No" )
Here's a link on how you can get existing records to update when you modify an auto-enter calculation: