Overview

The MATH function supports Date Math (e.g. years of service from hire date or age from birth date).

Examples

Some examples listed below:
Example Notes
Years([Today])-Years([BirthDate]) Age in years
Months([Today])-Months([BirthDate]) Age in months
Years([Today])-Years([HireDate]) Tenure in years
(Months([Today])-Months([HireDate]))/12 Tenure in years with decimals
Days([Today])-Days([OpenReqDate]) Days requisition has been open

All date functions (Years, Months and Days) calculate dates from midnight of January 1, 1970. For example, Years("1/1/2017") will return 47.


Reviewed 9/4/2017