Skip to Content

Functions AgeThisMonth, AgeThisYear and ExactAge

Functions are used in the formulas for calculating the rate and amount of the Salary Types, as well as in the calculated columns of the Settlements.

AgeThisMonth

Returned type Numerical
Context Salary Types, Settlements
Description The age the employee will be on the last day of the current month.
Example

AgeThisMonth

returns 61 for an employee born on March 10, 1966, if the accounting date of the pay slip is March 25, 2027. On February 25, 2027, the value returned would be 60.

AgeThisYear

Returned type Numerical
Context Salary Types, Settlements
Description The age the employee will be on the last day of the current year.
Exemple

AgeThisYear

returns 61 for an employee born on March 10, 1966, if the accounting date of the pay slip is February 25, 2027.

ExactAge

Returned type Numerical
Context Salary Types, Settlements
Description The employee's age
Example

ExactAge

returns 56 for an employee born on March 10, 1970, if the accounting date of the pay record is February 25, 2022. As of March 11, 2023, the value returned will be 57.

Functions AgeThisMonth, AgeThisYear and ExactAge