AGE(Date1, Date2)

Numeric Expression

Calculates and returns a numeric age based on a birthdate (Date1) and a reference date (Date2).

Arguments must be either QDS full date variables; Automatic Variables computed using DATEYMD(), or Automatic Variables of type Today’s Date.

Arguments may not be string expressions such as dates entered directly into function (e.g., AGE(10/17/1991,TODAY) or Automatic Variable string expressions (e.g., LONGDATE(TODAY)).

Examples:

AGE(DOB, TODAY)

AGE(DOB, INTERVIEW_DATE)