Date variables
Date variables
Below are listed date variables for salary formulas included under Date variables item in Formula Builder:
The following field and button are made available in Formula Builder after selecting specific variables under Date Variables:
VARIABLES
 |
If we want that the formula is going to work correctly we use formats of variables for dates.
It is importatant that we enter the date in a form LLLLMMDD.
|
Date variables from payroll preparation
Example:
|
|
The employee is entitled to a salary bonus is:
- If the payout date is later 15.12.2019, than the value is 0€ if the payout date is before than the value is 10€
- If the calculation date is before 15.12.2019, than the value is 50€ if the payout date is later than the value is 5€
|
In Formula Builder we use date variables DatePay – Payout Date and DateCalc – Report Date and we proceed by entering the conditions bellow in two new ET:
- In ET R11 we enter [#DatePay#<"20191215":0]10
- In ET R12 we enter [#DateCalc#>"20191215":50]5
This means:
- If the Payout date is smaller or before than the entered date, that the employee will receive bonus of 10€, but if the payout date is after the entered date, than the bonus is 0€
- If the Calculation date is bigger or after than the entered date, that the employee will receive bonus of 5€, but if the calculation date is before the entered date, than the bonus is 50€
Date variables from employment record
Example:
|
|
The employee is entitled to a length of service bonus if:
- If the start is later 01.01.2019, than the value is 0€ if the start date is before than the value is 0,5%
- John Doolitle started his employment on 15.12.2018 and Alice Knight on 01.10.2019
|
In Formula Builder we use date variable DateEnter – Start Date and create a new earning type:
In ET MN1 we create a formula [#DateEnter#<20190101:0,5]0
after the calculation we can see the results in preparation in a tab Pay Slip:
