I've updated this page: Field Management Dialog - Equations to clarify the use of the Auto-update checkbox:
---------------------------
If field equations involve the current date, check the Auto-update checkbox. IQ will recalculate all affected items on each change of day.
Warning: Auto-update can be a lengthy process, so use only when required.
An example when Auto-update is required, is the Urgency field, as the CalcUrgency function uses the current date (see "now" below) to get an Urgency number (>0 is late):
Function CalcUrgency(Due, Duration, PDone, Done) ' calculates an Urgency figure for tasks >0=late or will be late based on Duration and PercentDone
if isnull(Done) and not isnull( Due ) then
CalcUrgency = int( int(now) - int(cdate( nz( due ) )) + (nz(Duration) * (100-nz(PDone))/100 * 7/5) )
if CalcUrgency<-60 then CalcUrgency=null
else
CalcUrgency = null
end if
End Function
if isnull(Done) and not isnull( Due ) then
CalcUrgency = int( int(now) - int(cdate( nz( due ) )) + (nz(Duration) * (100-nz(PDone))/100 * 7/5) )
if CalcUrgency<-60 then CalcUrgency=null
else
CalcUrgency = null
end if
End Function
--------------------