[IS_BIRTHDAY] - Is Birthday

31-Aug-2022 · Felix Fung

What is this?

A Yes/No question variable.

Check whether the staff's next Birthday falls within the Pay Period.

What will the Value be Returned?

Y - if the staff's Birthday falls within the Pay Period.

N - if the Date of Birth is not defined, or the next Birthday doesn't fall within the current Pay Period.

Usage

Hightlight part content can be changed

If the condition is correct, return the 1st value. Otherwise, returns the 2nd value.

Payroll Variable Description Usage
[IS_BIRTHDAY]] Check whether the the staff's next Birthday falls within the Pay Period $1000 Birthday Bonus would be given to staff on their Birthday month
IIF('[IS_BIRTHDAY]'='Y',1000,0)