Date Math
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