Jim Lawrence
accessd at shaw.ca
Wed Apr 7 04:12:04 CDT 2010
Hi All: Another note on leap year; would it not be better to just do your own leap-year calculations? Do not include a leap day in a year divisible by 100 but not divisible by 400, otherwise years by divisible by 4 (all with no remainder of course) and that should be it. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Wednesday, April 07, 2010 12:22 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Date Difference As Completed Years-Months-Days Hi Stuart You are right. The catch is, as I have mentioned before, that "a month is not a month". This is why it makes no sense to be too specific about the difference in days. If you need an accurate measurement to the day, you will have to use a pure day count. Going beyond that - taking timezones and daylight saving in account - you need to count hours or even quarter hours, and even further down to take leap seconds into account. /gustav >>> stuart at lexacorp.com.pg 07-04-2010 08:37 >>> 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 > -------------------------------------------------- -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com