Age: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m →ACCESS: m |
||
| Line 5: | Line 5: | ||
=== Function to calculate Age === | === Function to calculate Age === | ||
====ACCESS==== | ====ACCESS==== | ||
*CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", DOB, Adm)) + Int(Format(Adm, "mmdd") < Format(DOB, "mmdd")), 1) | |||
**where Birth = [[Date of Birth]] and Adm = ([[Accept DtTm]] if available, [[Arrive DtTm]] otherwise) | |||
====SAS ==== | ====SAS ==== | ||