From CCMDB Wiki
Jump to navigationJump to search
Data Element (edit)
Field Name: age
CCMDB Label: not stated
CCMDB tab: not stated
Table: Created_variables_common table, Created_variables_CC table
Data type: number
Program: Med and CC
Created/Raw: Created
Start Date: 1900-01-01
End Date: 2300-01-01
Sort Index: 3

The number of years between Date of Birth and the last birthday prior to or on (Accept DtTm if applicable, Arrive DtTm otherwise).

Age is part of the APACHE II score for Critical Care and ALERT Scale used in Medicine.

Function to calculate Age

  • Both formula yields the same AGE values.


  • CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", DOB, Adm)) + Int(Format(Adm, "mmdd") < Format(DOB, "mmdd")), 1)



Do you still use the SAS formula, let's confirm it's all gone and all coming from CreatedVariables

  • SMW

  • Cargo

  • Categories
  • Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)
    • where Birth = Date of Birth and R_Adm = (Accept DtTm if available, Arrive DtTm otherwise)

Decided to keep this for now for cross-checking even though it duplicates the calculation in Access.

Related fields