how to calculate an age from 10/8/1943 to show yr,mth,dy.

's Computer Specifications

's Computer Specifications

"doctor who golf" <(E-Mail Removed)> wrote in message
news:1ADB4F33-CD32-4090-AE51-(E-Mail Removed)...

This will give you years and months. You should be able to figure out days
by adding a line to the code:

http://www.mvps.org/access/datetime/date0001.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

's Computer Specifications

On Sun, 12 Feb 2006 11:07:28 -0800, doctor who golf wrote:

>

Check "A More Complete DateDiff Function" at
http://www.accessmvp.com/djsteele/Diff2Dates.html
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do i calculate minumum but 0 (zero) must not show as the min	minimum	Microsoft Excel Misc	1	21st Oct 2009 08:48 AM
Calculate age - show months as well	KAquestions	Microsoft Access Forms	1	30th Jan 2009 04:49 PM
Why does 'calculate' show in the status bar, even after i hit F9?	Sam	Microsoft Excel Misc	1	20th Oct 2008 04:43 PM
how to calculate an age from 10/8/1943	=?Utf-8?B?ZG9jdG9yIHdobyBnb2xm?=	Microsoft Excel New Users	2	12th Dec 2005 05:12 PM
How to calculate and then show up as a percent?	Amuse	Microsoft Excel Worksheet Functions	1	10th Jul 2005 10:19 PM