Code

Re: Calculate age from input date.

MikeW — Mon, 28 Jun 2010 19:04:59 GMT

Hi.....I found your post now dated 4 years ago.....a simple solution which I need but I get a NaN return. The date of birth is read from a database as the form loads........any suggestions appreciated. Am using 2007

Thanks

Mike

Re: Calculate age from input date.

Tech264 — Thu, 27 May 2010 18:53:28 GMT

I have a form that has a data connection to a MS Access database and the fields are binded to a Birthdate field and a Age field. I copy and pasted the above formula in the age field and verified it with no errors. When I preview the form I get a NaN message in the age field. Wondering what I'm doing wrong here. Just trying to calculate the age of my patients. Thank you.

Re: Calculate age from input date.

BrownR — Tue, 22 Aug 2006 19:15:46 GMT

quote:
Originally posted by trufooser
Change the @DOB to the field which contains the date of birth.

trufooser,
Thank you for that post. Its just what I needed, and didnt even have to change the data field. One more tool to add to my chest!

Re: Calculate age from input date.

trufooser — Wed, 26 Jul 2006 14:35:39 GMT

much much easier way to do this (in my humble opinion). Cut and paste this formula into the default value of the control to store the age.

floor((number(substring(today(), 1, 4)) + number(substring(today(), 6, 2)) / 12 + number(substring(today(), 9, 2)) / 365.25) - (number(substring(@DOB, 1, 4)) + number(substring(@DOB, 6, 2)) / 12 + number(substring(@DOB, 9, 2)) / 365.25))

Change the @DOB to the field which contains the date of birth.

Re: Calculate age from input date.

Matt Faus — Wed, 25 Jan 2006 22:12:22 GMT

That blog is an awesome resource for what you're trying to accomplish. Could you post the code that you've written so far so we can see where your problems are and get you going in the right direction?

---------------
Matt Faus
InfoPath Dev Texas

Calculate age from input date.

BrownR — Wed, 25 Jan 2006 21:59:05 GMT

Hello all,
I'm working on a text box that calculates an age from a date Picker. I want the person to be able to input a date in a Date Picker and automatically calculate the personas age and display it in a text box. The only information that i could find was this one, http://blogs.msdn.com/infopath/archive/2005/01/25/360318.aspx

The BLOG does exactlly what i want but im having a heck of a time trying to code it, anotherwords I cant get it to work. Any help is appriciated.