Thank you for the help. Your comments have helped me to understand the operation of Auto-Enter better.
Using Auto-Enter suits my purposes better than an unstored calculated field, since I want to use the field as a condition for a TO that must be included in a portal. The idea of using the Evaluate function to trigger the update is very helpful. I can probably work out a solution using this method. Thanks again. ________________________________________________ Bruce Button Tel: 012-331-7072; Fax: 086-602-8247; Cell: 082-412-4972. PO Box 31442, Waverley, 0135, South Africa. Email: [EMAIL PROTECTED] -----Original Message----- From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Tim Mansour Sent: 12-January-2008 12:24 AM To: [email protected] Subject: Re: Update an autoenter calculation based on today's date 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 __________ NOD32 2785 (20080111) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com
