I have an age field and would like it to automatically update as time changes. I tried this script, but no luck. Any help?
Get ( CurrentDate ) - Family_Assigned::date_birth / 365
For a birth date of 8/3/2011 I got a result of 734655.
Must be an unstored calculation field. Cannot be an auto-entered value and result type must be Date, not number.
Here are a couple of custom functions that you could use in your unstored calculation field.
FileMaker Custom Function:Age ( date )
FileMaker Custom Function:Age ( birthday; today; format )
As philmodjunk mentioned, it needs to be an unstored calc.
Also, consider using this calculation, it will be more accurate.
Year ( Get ( CurrentDate ) ) - Year ( Birthdate ) - ( Get ( CurrentDate ) < Date ( Month ( Birthdate ) ; Day ( Birthdate ) ; Year ( Get ( CurrentDate ) ) ) )
Thank, works great
And my post was not fully correct. Result type should NOT be date.
Retrieving data ...