Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-09-20
Example: Calculate Worker Age as of July

Example: Calculate Worker Age as of July

This example illustrates how to create nested calculations.
To determine worker eligibility for bonuses, you want to identify workers who are 25 or younger on July 31st of the year when the bonus is paid.
As calculations have limited numbers of operands, you need to create multiple calculations and nest them. The nesting determines the order of operation, if you don't specify an
Order
 in the calculation.
To calculate July 31st of the year of the worker's payment, you need to:
  • Determine the year of the payment date.
  • Calculate July 31st of that year.
Then to calculate a worker's age, you need to calculate the difference between:
  • The worker's date of birth.
  • July 31st of the year of the worker's payment.
Security:
  • Set Up: Calculations - Generic
     domain in the Core Payroll functional area.
  • Set Up: Time Off (Calculations - Generic)
     domain in the Time Off and Leave functional area.
  1. Access the
    Create Build Date Calculation
     task.
    Enter these settings:
    Option
    Value
    Name
    Date: July 31 Current Year (based on Payment Date)
    Category
    Payroll
    Year
    Year: Payment Date - Year
    Month
    7
    Day
    31
  2. Access the
    Create Date Difference Calculation
     task.
    Enter these settings:
    Option
    Value
    Name
    Worker Age as of July Current Year (based on Payment Date)
    Category
    Payroll
    Interval
    Year
    Start Date
    Worker: Date of Birth
    End Date
    Date: July 31 Current Year (based on Payment Date)