Macropod (if you are by this way)
About 6 month ago you pointed me to a article on Woody's Lounge with Tips
and Tricks for calculating dates with fields. I was interested in the
calculating a person's age field. At the time I tested with my birthdate
12/31/1958 and the answer was dead on accurate. Today when I test that same
field the result is 45 years, - 4 months, -22 days vice the correct value 45
years, 8 months, 9 days.
I attempted to locate your article again today to see if I had somehow
corrupted the fields, but links from some of your previous posts on the
subject are not pointing to the article anymore.
I have managed to cobble together a painfully complex field to generate the
correct answer. I can't hope to duplicate it here, but if you are
interested I have it posted here:
http://gregmaxey.mvps.org/Date_Field.doc
If you have any suggestions for simplifying, I would certainly appreciate
it.

Signature
Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in gmaxey@whamspammvps.org
macropod - 10 Sep 2004 23:25 GMT
Hi Greg,
I've just tested with the current version (2.4), which is still available
at:
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902
(url all one line)
With your d.o.b., today (10 September 2004) I get:
If your Date of Birth was 31 December 1958, then your age is 45 Years, 8
Months and 10 Days.
Seems near enough for me!
Cheers
> Macropod (if you are by this way)
>
[quoted text clipped - 17 lines]
> If you have any suggestions for simplifying, I would certainly appreciate
> it.
macropod - 10 Sep 2004 23:27 GMT
Oops, make today's date 11 September 2004!
Greg Maxey - 10 Sep 2004 23:39 GMT
Macropod,
Yes there are differences between the file I had and what is posted as the
current version. I am getting the correct result also using the current
version. Thanks.

Signature
Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in gmaxey@whamspammvps.org
> Hi Greg,
>
[quoted text clipped - 42 lines]
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.736 / Virus Database: 490 - Release Date: 9/08/2004