Date Calculation Field Hitch

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 he

http://gregmaxey.mvps.org/Date_Field.doc


If you have any suggestions for simplifying, I would certainly appreciate
it.


--
Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in

Hi Greg,

I've just tested with the current version (2.4), which is still available
at:
http://www.wopr.com/cgi-bin/w3t/show...&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


"Greg Maxey" wrote in message
...
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 he

http://gregmaxey.mvps.org/Date_Field.doc


If you have any suggestions for simplifying, I would certainly appreciate
it.


--
Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.736 / Virus Database: 490 - Release Date: 9/08/2004

Oops, make today's date 11 September 2004!


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.736 / Virus Database: 490 - Release Date: 9/08/2004

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.

--
Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in

macropod wrote:
Hi Greg,

I've just tested with the current version (2.4), which is still
available at:
http://www.wopr.com/cgi-bin/w3t/show...&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


"Greg Maxey" wrote in message
...
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 he

http://gregmaxey.mvps.org/Date_Field.doc


If you have any suggestions for simplifying, I would certainly
appreciate it.


--
Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.736 / Virus Database: 490 - Release Date: 9/08/2004