Solved

Convert birthdate into age.

Posted on 2006-10-31
6
1,286 Views
Last Modified: 2012-06-21
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..
0
Comment
Question by:louy3
6 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 200 total points
ID: 17842425
Not sure what you mean by a CHECK on the formula tree.

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

mlmcc
0
 
LVL 6

Assisted Solution

by:Ken Turner
Ken Turner earned 200 total points
ID: 17842605
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)?
0
 
LVL 28

Assisted Solution

by:bdreed35
bdreed35 earned 100 total points
ID: 17842947
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.
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
LVL 9

Author Comment

by:louy3
ID: 17844051
Still not working...but closer.  Age is coming up with a number..  30166
0
 
LVL 28

Expert Comment

by:bdreed35
ID: 17844238
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
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 17844400
Glad i could help

mlmcc
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

806 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question