trouble with a date field - 03-11-2011 , 06:04 PM
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.
Re: trouble with a date field - 03-11-2011 , 10:31 PM
On Mar 11, 5:04*pm, "Stephen Larivee" <larive... (AT) yahoo (DOT) com> wrote:
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.
Re: trouble with a date field - 03-12-2011 , 09:58 AM
"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.