Functions DayOf, MonthOf and YearOf
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.
DayOf(date)
| Type returned | Numerical |
| Context | Salary Types, Settlements |
| Parameters | Type | Description |
| date | Date | Date |
| Description | The day of the date entered in the parameters. |
| Example |
DayOf(DateValueSalary) returns 24 if DateValueSalary = 24.10.27. |
MonthOf(date)
| Type returned | Numerical |
| Context | Salary Types, Settlements |
| Parameters | Type | Description |
| date | Date | Date |
| Description | The month of the date entered in the parameters. |
| Example |
MonthOf(DateValueSalary) returns 10 if DateValueSalary = 25.10.27. |
YearOf(date)
| Type returned | Numerical |
| Context | Salary Types, Settlements |
| Parameters | Type | Description |
| date | Date | Date |
| Description | The year of the date entered in the parameters. |
| Example |
YearOf(DateValueSalary) returns 2027 if DateValueSalary = 21.10.27. |
Français
Deutsch
Italiano