Want to Calculate 'Age' 1

[SmpTraining]

Has anyone got a neat formula to calulate the Age of someone at a given date.

My report accepts a parameter field of {?date} and I have a Date of Birth field called {DOB}.

DateDiff does not do the job.
Subtracting the dates then dividing by 365.25 is the nearest solution I'm using at the moment.

I was hoping someone out there has a neat solution to this basic problem.

Many thanks in advance. Steve Phillips, Crystal Consultant

 

[dgillz]

I had this one recently and being the pagarist that I am I got it off of Ken Hamady's website. Here's the link

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

Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[SmpTraining]

What a star! Perfect. (....and thanks to Ken too!!) Steve Phillips, Crystal Consultant