[AccessD] Age calculation

Steve Schapel miscellany at mvps.org
Tue Jun 26 14:29:00 CDT 2007


Susan,

Susan Harkins wrote:
> Whether or not it should default to March 1 or February 29 is subjective --

I don't think this is correct.  I think it's not "free choice", nor is 
it a logically arguable proposition.  Like so many things, it is a 
matter of generally accepted convention.  My understanding of the normal 
convention is that a 29 Feb birthday occurs on 28 Feb in non leap years. 
  I agree with you that in most circumstances, it is not of 
earth-shattering importance.  But reading this thread was the first I 
was aware that there are some who do not adhere to this convention.

> .... Nonetheless, the software
> doesn't agree with you. 

What software?  One of the points made by Gustav is that the software 
(Access) *does* agree with him.  For example, the DateAdd function 
behaves according to the convention.  The software does not provide an 
Age function.  That means you have to work it out yourself.  What does 
not agree with Gustav is not the softweare, it is some people's commonly 
used attempts to work it out themselves.

The way in which I "work it out myself" has now changed, as a result of 
Gustav pointing out this leap year problem.

Regards
Steve



More information about the AccessD mailing list