Crystal Reports Calculate Age

Report Design
Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design

Topic: Calculate Age

Author	Message
MW2011 Newbie Joined: 26 Jun 2012 Location: United States Online Status: Offline Posts: 5	Topic: Calculate Age Posted: 26 Jul 2012 at 11:21am
	I have a field on my report called birthday, I have a need to display the persons age on the report. How does one go about that? I already have a function in my application called calcAge which takes an input and returns the persons age. Just dont know how to use it in my CR. Thanks MW2011
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3701	Posted: 27 Jul 2012 at 11:53am
	You can't use a function in an application to do this unless the function is in the database, in which case it can be called either in the select statement of a command or, if you're using just tables/views on your report, you can create a SQL Expression that will call the function. If this is not in your database, you'll need to recreate the logic for it in a Crystal formula. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Vermont Data Newbie Joined: 30 Jul 2012 Location: United States Online Status: Offline Posts: 2	Posted: 30 Jul 2012 at 3:21am
	I ran into this problem and created a variable called age today. The way it works is to subtract Date_of_birth from Current_date. This returns the number of days someone has lived. Then I divide that by 365 (yep I ignore leap years) which give me a number with lots of decimals. The next step if to kill those decimals, so round the number up and subtract 1. Here is the code: Roundup((CurrentDate - {patient_current_demographics.date_of_birth}) / 365)-1 Edited by Vermont Data - 30 Jul 2012 at 3:24am
	Joe Murray
	IP Logged

Vermont Data Newbie Joined: 30 Jul 2012 Location: United States Online Status: Offline Posts: 2	Posted: 30 Jul 2012 at 3:23am
	Opps I mean 365 not 360 in the formula
	Joe Murray
	IP Logged

MW2011 Newbie Joined: 26 Jun 2012 Location: United States Online Status: Offline Posts: 5	Posted: 30 Jul 2012 at 11:59am
	I ended up doing almost exactly like you did. Worked like a champ. Someone told me to put the .25 because of leap year. INT((CurrentDate - {AddTenants.Birthday}) / 365.25 ) MW2011
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.