On 12/01/2008, at 8:00 am, Bruce Button wrote:
I have an Auto-Enter calculation based on today's date (using
Get(CurrentDate)). I would like this calculation to update whenever
the
date changes. I have tried things like making a calculated field
called
Today and putting the Get(CurrentDate) function in that field. The
Today
field updates fine, but the Auto-Enter calculation will not update.
In your auto-enter settings have you un-checked the option "Do not
replace existing value of field"? If this is left checked, your auto-
enter calculation will only happen once, when the record is created.
But moreover, the calculation will only be performed if a field in the
calculation is edited. For instance, if the field StartDay has this
auto-enter calculation:
StartDay = DayName ( StartDate )
then StartDay will be updated each time StartDate is edited. However,
if your calculation is simply
StartDate = Get ( CurrentDate )
then this would only be performed when the record is created. One way
of forcing the calculation to be performed would be to use the
Evaluate function, which allows you to specify a list of fields that
trigger the evaluation of the formula:
StartDate = Evaluate ( "Get ( CurrentDate )"; Company; Address;
Name )
which can be interpreted as "calculate the current date whenever
Company, Address or Name are edited". But remember this will work only
in the current record ... so depending on your exact needs you may
just have to rely on an unstored calculated field which will
recalculate the current date as required.
--
Tim Mansour <[EMAIL PROTECTED]>
Neologica Print & Promotions (ABN 63 904 335 408)
159 Commonwealth Street Surry Hills NSW 2010
Sydney 02 9212 1789 Melbourne 03 9012 7441 Mobile 0405 500 846
