Date Calculation Field Hitch

[Greg Maxey]

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.

 

[macropod]

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]

Oops, make today's date 11 September 2004!

 

[Greg Maxey]

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.