Add Years to Date

[steigrafx]

I'm having a difficult time figuring out how to do something which I think is simple.

I have a date_of_birth field. I have another field I need to populate with the person's 21st birthday date. I just need to add 21 to the person's birth year, but I can't figure out how to do it.

I'd appreciate your help.

Thanks,

Kevin

*** Thanks, but I figured out my problem. I stupidly forgot to change the calculation result to date instead of number. Works fine now with this calculation:

Date (Month (Child_1 DOB) ; Day (Child_1 DOB) ; Year (Child_1 DOB) +21)

[comment]

Date (Month (Child_1 DOB) ; Day (Child_1 DOB) ; Year (Child_1 DOB) +21)

That is the correct answer. However, the existence of a field named Child_1 DOB raises a red flag. Hopefully, you do not have a dedicated field for each child, e.g. Child_2 DOB, Child_3 DOB, etc.

[steigrafx]

Actually, I do have separate fields for each. I'm not using it as a database, but more like a spreadsheet to perform calculations (something called the Kaiser Formula). It's used in wrongful death cases to calculate life expectancy, remaining years of dependency on the decedent had the decedent survived, and percentage of recovery awarded to each family member.

The "database" is used to double check attorneys' calculations prior to submission to a judge for their signature. The records are not saved.

Thank you,

Kevin

[Vaughan]

Interestingly, Microsoft's Azure cloud service spectacularly BROKE on 29 February this year (2012). The cause was that the programmers had calculated an expiry date one year into the future simply by getting the Day, Month and Year+1. This produced 29 February 2013 which is invalid date.

Unbelievable that they'd do something as dumb as this.