How to use "Birthday" field to calculate age on a certain date?

[creolejazz]

I've got a table with a "Date of Birth" field and an "Age" field. Those fields are also included in my form. When completing the form I would like to fill in the "Date of Birth" field and have it automatically complete the "Age" field with how old that person would be on, say, June 29, 2009. Possible? How? Thanks.

 

[RuralGuy]

Have you done a search here on "age" yet? There should be tons of hits. Just modify an age function to accept the date as well as the DOB. Post back if you are still having trouble.

 

[John Big Booty]

Try this one for starter