General

Re: Calculation question

Brenda — Mon, 12 Apr 2010 22:26:43 GMT

I read the article and it made sense until I tried to apply it. I couldn't figure out where to start. Then it donned on me that perhaps this is for a 2007 or higher version (I forgot to mention that I'm working in 2003 InfoPath and 2003 Access)?

Brenda

Re: Calculation question

Alec Pojidaev — Mon, 12 Apr 2010 13:30:00 GMT

Check out this link:

http://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/

Calculation question

Brenda — Fri, 09 Apr 2010 23:39:16 GMT

I have a form with a data connection to an Access database. I don't need to store the age of a person in the database because I have it automatically calculated from the birthdate (DOB) field. However, I would like to have the InfoPath form calculate in a different field when an end user fills in the DOB field. Is it possible?

If it helps in finding a solution, I use the following formula in Access: DateDiff("yyyy",[DOB],Date())+(Format([DOB],"mmdd")>Format(Date(),"mmdd")).
Do I use the same or does InfoPath do things differently? :-)

Thanks,
Brenda