Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Schapel, Steve
  New Posts New Posts RSS Feed - Deriving Age from Date of Birth
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

Deriving Age from Date of Birth

 Post Reply Post Reply
Author
Message
Steve Schapel View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 04 Jul 2009
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote Steve Schapel Quote  Post ReplyReply Direct Link To This Post Topic: Deriving Age from Date of Birth
    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

Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down