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

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.

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

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' )