How to calculate @age?

[bhfmc]

How do I calculate a parameter field, @Age, given a parameter field, @Date-on-which-age-is-calculated, and a data field, BIRTHDATE? CR 8.5.

 

[vidru]

Here's a faq on this... faq767-4120.

Haven't tried it, so I can't vouch for it...

-dave

 

[synapsevampire]

Or use Ken Hamady's formula:

http://www.kenhamady.com/form06.html

-k

 

[bhfmc]

dave and k,
Thank you for the quick response. I adapted Ken Hamady's formula with success. Thank you synapsevampire once again!