AGE

Returns the number of years between two dates.

Reporting Area(s)

Names

Required Parameters

1. Date field from the Names table (i.e. nmbirth, nmaddate, nmupdate)

Optional Parameters

2. Date field (i.e. nmaddate, nmupdate, nudfd1). Default is System (current) Date.
3. Character return value: "0" (zero) returns blank space instead of 0 (zero) if age is less than 1 (one).

Example(s)

AGE(nmbirth) returns number of years from date of birth to system date

AGE(nmbirth,nudfd1,"0") returns number of years from birth date to Name User Defined date field 1. Returns nothing if age is less than one.

Notes

If no 2nd parameter is entered, the function will calculate aged based on system (current) date.

Related Functions

AGECL