Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Date Difference

Date Difference

Security:
Custom Field Management
 domain in the System functional area.
You can set up the calculated field to compute the difference between 2 dates or times. Workday rounds down the results to the nearest whole number.
  1. Access the
    Create Calculated Field
     task.
  2. Select
    Date Difference
     for the
    Function
    .
  3. As you complete the
    Calculation
     tab, consider:
    Option Description
    Start Date Field
    Select a field associated with the business object as the starting date for the calculation.
    Example:
    Hire Date
    .
    End Date Field
    Select a field associated with the business object as the ending date for the calculation.
    Example:
    Termination Date
    .
    Return Zero on Error
    Select the check box to return a zero value instead of displaying an error if the
    Start Date Field
     or
    End Date Field
     return a blank value.
    Example: If you hired a worker on 01/01/2020 and they're an active employee, they wouldn't have a termination date. If the
    End Date Field
     is
    Termination Date
    , Workday returns a blank value for the worker. Select the check box to display a zero instead of an error.
    If you use a Prism business object with this calculated field, Workday always returns a zero on error.
    Ignore Lower Level Date Components
    Select to enable Workday to ignore sublevel date or time values during calculation.
    Example: If you don't select the check box, the difference between 04/01/2006 and 02/15/2008 is 1 year. If you select the check box, the difference is 2 years because Workday computes the years, ignoring the day and month values.
You can calculate the difference between 2 dates, such as the:
  • Days remaining before a worker returns from leave.
  • Days since a position opened.
  • Months since a worker back-dated or forward-dated an expense report.
  • Worker's age in years, as of 01/01/2019.
  • Create additional calculated fields.
  • Create new calculated fields from within a date difference calculated field.