[AccessD] Date Difference As Completed Years-Months-Days

Stuart McLachlan stuart at lexacorp.com.pg
Wed Apr 7 01:37:46 CDT 2010


So four children born on four different dates are all exactly the same age ( one month old)  on 
28 Feb 2003?

Will they all be the same age on 1 March 2003?

Or will one of them suddenly age by four days while another one only ages by one day?

The real answer to "How can you calculate a date difference as completed years-months-
days"  is "You can't!"  -  At least not consistently - since the units are not consistent multiples 
of each other.   

-- 
Stuart

On 7 Apr 2010 at 10:57, A.D. Tejpal wrote:

> --------------------------------------------------
> 28-Jan-2003    28-Feb-2003    1 Month
> 29-Jan-2003    28-Feb-2003    1 Month
> 30-Jan-2003    28-Feb-2003    1 Month
> 31-Jan-2003    28-Feb-2003    1 Month
> --------------------------------------------------




More information about the AccessD mailing list