ActPresentation.com HOME FAQ FORUM info@ActPresentation.com
Phorum: speed & power.

ActPresentation.com


Add-ons for Sage ACT! CRM

ACT! addons by ActPresentation.com : Abacus Calculated Fields, PicturePlus, Quick Navigation List, Employment History, Quick Search, Presentation for ACT!

Age Calculator

Posted by: Brad

Date: March 22, 2007 01:27AM

I only need the Age Calculator. Is there a package that includes only this option?

Re: Age Calculator

Posted by: Admin

Date: March 22, 2007 04:30AM

Brad Wrote:
-------------------------------------------------------
> I only need the Age Calculator. Is there a
> package that includes only this option?

Brad,
There is no package that includes only AGE function.
You can calculate age using Abacus Calculated fields add-on.
Formula that calculates age in years should look like this :

Age( [Your_Date_Field] )

If you need to calculate age for example in years and months - you can use DATEDIFF function.
E.g. :

'Age = ' + ToStr( Age( [Your_Date_Field] ) ) + ' years and ' + ToStr( DATEDIFF(month,[Your_Date_Field],getdate()) % 12 ) + ' months' 

Comments:
Function getdate in this formula returns current date.
DATEDIFF function calculates difference in months between [Your_Date_Field] and current date.
% operator is used to get reminder.
ToStr function is used to convert numbers to strings ( characters ).



Edited 1 time(s). Last edit at 03/24/2007 12:32PM by Admin.

Re: Age Calculator

Posted by: Eliot

Date: August 22, 2007 09:08PM

Can I show age out to 2 decimal places with this tool. Like age = 52.43?
Thanks, E

Re: Age Calculator

Posted by: Admin

Date: August 23, 2007 10:27AM

The following formula calculates age as decimal number :

ToDec(DATEDIFF(month,[Birth Date],getdate())) / 12

If you want 2 decimal digits - you can also apply FORMAT function as shown below :

Format ( ToDec(DATEDIFF(month,[Birth Date],getdate())) / 12, '.00' )

ACT! software CRM addons - best plugins for ACT contact management software ( Act! by Sage software : ACT!2005, ACT!2006, ACT!2007, ACT!2008, Act by Sage Premium for Workgroups ).
Custom addon solutions ( ACT! add ons ) development and CRM (Customer Relationship Management) software training and consulting.