Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / September 2004

Tip: Looking for answers? Try searching our database.

Date Calculation Field Hitch

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Greg Maxey - 10 Sep 2004 04:23 GMT
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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.