[AccessD] Age calculation

Charlotte Foust cfoust at infostatsystems.com
Tue Jun 26 14:32:55 CDT 2007


Maybe Susan has been watching the Pirates of Penzance, since the whole
plot (such as it is) is based on someone who is not of age because his
birthday of February 29 only occurs every 4 years!  LOL

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Tuesday, June 26, 2007 12:29 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Age calculation

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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list