Age of Birth

[Snookless]

synapseVampire,
I tried your formula and get the following message upon previewing report "A Month number must be between 1 and 12", I can click Ok to this and then the report works fine.....any Ideas?



Madawc, I used your formula and recieved an age one year older then the correct Age...Ideas?

 

[synapsevampire]

Here's a link to several approaches:

http://www.crystalkeen.com/articles/crystalreports/agecalculation.htm

-k

 

[Snookless]

Thank You