Automatically updating get(CurrentDate) calculation.

[Forum Joe]

I have a field that is the date a job is sent away, I need to keep track of the total length of time a job is away for.

I've currently got a field that is a calculation, TimeAway=If(Date Returned>0;Date Returned-Date Sent;Get(CurrentDate)-Date Sent).

So if there's a date in the date returned, it gives the number of days it's away for, that works fine.

If there's no date in the "date returned" field it the calculation works when I manually change the date sent field, but it doesn't update each day. How can I force it to recalculate the field every day?

[LaRetta]

In the calc's field definition, go to Storage Options and make the calc unstored.