Convert birthdate into age.

louy3
louy3 used Ask the Experts™
on
Here's what I am using..  Truncate((CurrentDate - {ScheduleAllocations.Birthdate}) / 365.25)  I see that this works for some..  No errors, but the formula tree does not have a "check" on it??  Hope that makes sense.. thanks in advance..
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Not sure what you mean by a CHECK on the formula tree.

You could also use
Truncate(DateDiff('y',CurrentDate,{ScheduleAllocations.Birthdate})

mlmcc
Could the lack of a "check" on the formula tree be because you've created the formula, but you haven't placed it on your report (or used it in another formula)?
Top Expert 2004
Commented:
In order for a field to have the green check mark, you have to use it somewhere on the report.  Just because you create it, doesn't mean the report will use it.
As far as the formula goes for age, the only accurate method I know of to get the age is found here on Ken Hamady's site: http://kenhamady.com/form06.shtml
The method you are using will be accurate most of the time but could be off as much as 1 day a year.
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

Author

Commented:
Still not working...but closer.  Age is coming up with a number..  30166
Top Expert 2004

Commented:
Did you try it with the formula from the link I posted:

WhileReadingRecords;
DateVar Birth:= {ScheduleAllocations.Birthdate};
DateVar Ann := CurrentDate;
if (Month(Ann) * 100) + Day (Ann) >=(Month(Birth) *100) + Day (Birth)  
then Year (Ann) - Year(Birth)  
else Year (Ann) - Year(Birth) -1
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Glad i could help

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial