Schapel, Steve - Deriving Age from Date of Birth

Print Page | Close Window

Deriving Age from Date of Birth

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Schapel, Steve
Forum Description: Steve Schapel's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=476
Printed Date: 18 Apr 2024 at 9:51pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: Deriving Age from Date of Birth

Posted By: Steve Schapel
Subject: Deriving Age from Date of Birth
Date Posted: 04 Jul 2009 at 12:26pm

Deriving Age from Date of Birth, Allowing for Leap Years

I guess it’s a common mistake, especially for those new to database work, to store the Age of a person in a database table.

Of course, the main reason that this is a bad idea is that age changes, so keeping the stored data accurate in such a case becomes a near impossibility.

The usual advice, therefore, is to store the Date of Birth (which does not vary), and calculate the Age whenever it is required for the purposes of the database application...

Read more here: http://accesstips.datamanagementsolutions.biz/correctage.htm - http://accesstips.datamanagementsolutions.biz/correctage.htm

-------------
Steve Schapel
http://accesstips.datamanagementsolutions.biz/ - http://accesstips.datamanagementsolutions.biz/