Infopath: how do I calculate "age" from d.o.b. date-picker field

[larune]

I need a form that calculates date field from date of birth entered as a
date-picker field. can this be done with Infopath field rules, or do I need
to invoke VB?

 

[Scott L. Heim [MSFT]]

Hi,

To execute date calculations in InfoPath you will need to write custom code
- take a look at the following BLOG entry as it should provide what you
need:

http://blogs.msdn.com/infopath/search.aspx?q=date+calculation&p=1

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[S.Y.M. Wong-A-Ton]

It is possible to use rules and functions within InfoPath to calculate a
person's age from a given date of birth. A possible solution for this
calculation without custom code has been posted here:
http://enterprise-solutions.swits.net/infopath/calculating-age-from-date-of-birth.htm

 

[Bob B]

I followed you instructions to calculate a person's age. Except under the
conditon for action 3. It would not except Set a field's value: age < 0. I
changed to age< 0. When I put in a date nothing show in the dob field.
Could I have a syntax error? or what.

 

[S.Y.M. Wong-A-Ton]

Sorry for the delay in responding, and thank you for pointing out the
mistake. Actually, the article contained several mistakes.

There is no set a field's value for conditions. You need to just select
"age" from the first drop-down, "is less than" from the second, and type in
zero in the text field when you're in the Conditions dialog box.

I've corrected the article to contain slightly less faulty instructions. See
http://enterprise-solutions.swits.n...ulating-age-from-date-of-birth&c=infopath2003

Hope that works for you now.

 

[Bob B]

I had figured out the fix for the 3rd action. Now I'm getting the error
"Some rules are not applied, uspecified error" This is occuring on the 2nd
action conditions, because when I bypass error the age is not being calculate
right when DOB is in some month or year.

 

[S.Y.M. Wong-A-Ton]

Did you create the form from scratch by following the instructions? Or are
you trying to incorporate it in a form you already had? It could be that the
location of your nodes in the main data source differ from what is specified
in the article. Other than that, I cannot think of anything.

I've recreated the form for you and posted it here:
http://enterprise-solutions.swits.net/infopath2003/calcagedob.zip

I will remove this link soon! Download the file, unzip it, right click on
the XSN and choose Design.

 

[Bob B]

I finally got it to work. Thanks for staying with me.

 

[S.Y.M. Wong-A-Ton]

Well done! And no problem.

 

[Bobby]

Your instructions for this work great! However, I have the need to calculate
the age in months and not years. What rule should I delete/add/change to do
this? Thanks!

 

[S.Y.M. Wong-A-Ton]

You could change both age actions to multiply by 12. For example, the first
action would become

age = (number(substring(today(), 1, 4)) - number(substring(., 1, 4))) * 12

and the second one would become

age = (number(substring(today(), 1, 4)) - number(substring(., 1, 4)) - 1) * 12

But this would not give you the amount of months to date. The logic to do
that would become too complex for rules, so I would recommend writing code if
you want to calculate the exact amount of months until the day of today.