calculating exact age and workingyears
Peter Klaassen - NCC vof
info at nccdatabank.nl
Wed Nov 24 04:51:12 PST 2004
For this I use in the automatic processing:
:'employmentdate is 10,DMYY/
:'birthdate is 10,DMYY/:
:
:ja(6,.3);la(6,.3);jr(2,.0);lt(2,.0):
:
:ja=((@td-employmentdate)/"364.25");la=((@td-birthdate)/"364.25"):
:
:jr=ja;lt=la:
:@td lt (mid(employmentdate,"1","6"){mid(@td,"7","4"))
:jr=ja-"1":
:@td lt (mid(birthdate,"1","6"){mid(@td,"7","4"))
:lt=la-"1":
calculating total amount op days, deviding by 364.25 into an
.3 variable, placing it in a .2 varibale concluding by checking if
todaysdate is less than the birthdaydate.
this however not always results in the correct figures.
I can't trace the error I make.
isn't there an easier way within filepro processing in presenting the
exact age and/or years op employment?
--
regards,
Peter Klaassen - NCC vof
Havenweg 22 B, 8899 BC Vlieland, The Netherlands
info at webyachts.nl - http://www.webyachts.nl
T +31-562-453015 F +31-562-453088
Skype: peterklaassen
More information about the Filepro-list
mailing list