AnsweredAssumed Answered

Updating Un-Stored Calculations via Server

Question asked by Jason_Farnsworth on Jan 10, 2017
Latest reply on Jan 10, 2017 by philmodjunk

I have a series of date fields that expire (or need to expire). Currently they do not - UnStored


I have them set to unstored for two reasons - First performance second I have conditional value lists only grabbing current dates.


Not expiring is a big deal -


The present idea is to run a server script at night the basically updates each record to grab a new stored value. The dates only need to update once per day to be current.


Do I need to troll over each record in the table and copy a field to itself or will updating one record in the table update all of them?


Is this the best option to handle this function?


Please advise,


Thanks in advance