I have a field called DOB and it is a date field. Everyone's date of birth
is in the field. I created an AGE field and used this calculation:
(Get ( CurrentDate )-DOB)/365.24
and set it to display a Number.

When I created this a few months ago, it was working fine. But the Ages do
not seem to be updating correctly. I spot checked and some of them are
definitely off by several months.

Is there something wrong with my formula?

The file is on a FMP Windows server and is being used with Windows FMP 11 by
about six staff members.

Any help would be appreciated.

On Mar 11, 5:04*pm, "Stephen Larivee" <larive... (AT) yahoo (DOT) com> wrote:
There are two issues.

One is the field storage options must be set to "Do not store...".
Your field won't update without that and Filemaker will always think
Get(CurrentDate) is the date you created the field or the record.

The other is your age calculation will not always be accurate. It'll
be off by a day or few for a subset of ages. Calculating age is
surprisingly annoying. This function seems like an elegant solution,
but I have tested it: http://www.briandunning.com/cf/79.

DJ

"David Jondreau" <david (AT) wingforward (DOT) net> wrote


You were right. When I changed the storage, everything cleared up. Thank
you. I will check out your link later.