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:

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:

1. In ET R11 we enter [#DatePay#<"15.12.19":0]10

2. In ET R11 we enter [#DateCalc#>"15.12.19":50]5

If we want that the formula is going to work correctly we use formats of variables for dates.

This means:

1. 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€
2. 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€