Skip to Content

Function Birthday

3700  Formulas, functions and formats

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.

Birthday(age)

Type returned Boolean
Context Salary Types, Settlements
Parameters Type Description
age Numerical Age to test or 0
Description

If the Age parameter ≠ 0 :

1 if the employee reaches the age corresponding to the value passed as a parameter the month and year of the accounting date of the pay slip, otherwise 0.

If the Age parameter = 0 :

1 if the employee’s birthday is in the month of the accounting date of the pay slip, otherwise 0.
Examples

Birthday(40)

returns 1 for an employee born on March 10, 1987, if the accounting date is March 25, 2027.

Birthday(0)

returns 1 for an employee born on March 10, if the accounting date is March 25, 2027.
Function Birthday