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