General

Re: Calculate age in years from birth date

Ame1904 — Wed, 03 Nov 2010 14:52:54 GMT

thank you for such a quick reply, works now. Thanks

Re: Calculate age in years from birth date

Jimmy — Wed, 03 Nov 2010 14:25:00 GMT

This formula should also work:

(substring(today(), 1, 4) - substring(birthDate, 1, 4)) - 1 * (translate(substring(today(), 6, 5), "-", "") < translate(substring(birthDate, 6, 5), "-", ""))

Re: Calculate age in years from birth date

princevis — Wed, 03 Nov 2010 14:22:01 GMT

http://www.bizsupportonline.net/infopath2003/calculating-age-from-date-of-birth-infopath-rules-formulas.htm

Try this, this examp[le has worked for me. let me know if u find some issues.

Calculate age in years from birth date

Ame1904 — Wed, 03 Nov 2010 14:13:51 GMT

Sorry if this has already been posted but can someone explain the formula to calculate the age of a person from their birthdate. Have tried a few but none of them work. Probably terribly easy!

Thanks in anticipation