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
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#<"15.12.19":0]10
- In ET R11 we enter [#DateCalc#>"15.12.19":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€

