Age calculation based upon date of birth and date of death in years, months and days.

Forum|Forum|4 years ago
June 6, 2021
3 답변들
19195 조회

I'm so sorry if I am asking for the 100th time, but i've searched so many posts and not seeing exactly what I need. I work for a funeral home and we are now typing our arrangement information instead of hand writing them. For our obituaries we always have to calculate the final age in years, months and days. I thought if I could do a script to calculate it for me, it would save some time! But, I know nothing about scripts in adobe. Can somebody help me with the code? My document will have the date of birth field and the date of death field, now I just need to have it calculate in years, months, and days in my age field. PLEASE HELP!

JavaScript

이 주제는 답변이 닫혔습니다.

최고의 답변: bebarth

Thank you!! Now, how can I change things in order to put the month first versus typing the day?

You have to change:
...
if (util.scand("mm/dd/yyyy",this.getField("Deathday").valueAsString)>=util.scand("mm/dd/yyyy",this.getField("Birthday").valueAsString)) {
...
var DoB=parseInt(birthday[1]);
var MoB=parseInt(birthday[0]);
...
var DoD=parseInt(deathday[1]);
var MoD=parseInt(deathday[0]);
...
That's all for the script.
You also have to change the format of both date fields. Remove the script before changing them, else you will have the alert message!!!
@+

ls_rbls

Community Expert

Also explore this discussion for additional insights:

https://community.adobe.com/t5/acrobat/calculating-age/td-p/11467644

In particular, see the contribution provided by NesaNurani about leap year and roll over dates.

try67

Community Expert

This might seem like a simple calculation, but it's not. Is it really necessary to show the exact number of days, months and years? Why not just an age in years?

Ashley Akers작성자

Known Participant

Yes, it is necessary. We go to websites that have these calculators currently, but trying to save an extra step.

bebarth

Community Expert

No, @5833724, that calculation isn’t correct as far as I can see. I’m using this site: Date Duration Calculator: Days Between Dates (timeanddate.com).

From and including: Monday, March 31, 1980
To and including: Friday, January 1, 2021
Result: 14,887 days
It is 14,887 days from the start date to the end date, end date included.
Or 40 years, 9 months, 2 days including the end date.
Or 489 months, 2 days including the end date.

@Ashley Akers, have you tried asking a site like this if you can license or purchase a copy of their calculation script (is it javascript?) and then running that script inside Acrobat? Is it the different number of days in each month that makes it too difficult for Acrobat's calculation methods? Is it a custom validation script you need? Which field property would you use?