calculating exact age and workingyears

Peter Klaassen - NCC vof info at nccdatabank.nl
Wed Nov 24 09:10:23 PST 2004


Date sent:      	Wed, 24 Nov 2004 09:44:04 -0500
From:           	Kenneth Brody <kenbrody at bestweb.net>
Subject:        	Re: calculating exact age and workingyears
To:             	info at nccdatabank.nl
Copies to:      	filepro-list at lists.celestial.com

> And why do you subtract 1 from the fields if today is prior to the
> anniversary?

because before someones birthday he still is in your case 43 and not 
44.
 
> Also, is there a reason you do the calculation into a .3 field and
> then move the result into a .2 field?

I move to a .0 field
 
> Perhaps if you can explain exactly what you are trying to calculate?

I want to show the exact age in years everyday in iua.

> If tomorrow were my 44th birthday, what number do you want?

43 today and 44 tomorrow
 
> What if I were born on January 1st, and today was December 31st?

44 of course


Peter


More information about the Filepro-list mailing list