Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-11-01
Reference: Date Calculations

Reference: Date Calculations

These calculations return a date.
Security:
  • Set Up: Calculations - Generic
     domain in the Core Payroll functional area.
  • Set Up: Time Off (Calculations - Generic)
     domain in the Time Off and Absence functional area.
  • To configure access to calculations using segment-based security groups:
    Access Calculation (Segmented)
     domain in the Core Payroll, Implementation, Payroll Interface, and Time Off and Leave functional areas.
Name
Description
Examples
Tips
Build Date Calculation
Builds a date by combining a year, month, and day.
  • Current fiscal year start date.
    Current year anniversary date for a worker.
  • Based on a given year, define a month of 12, and a day of 31 to return the year-end date.
To configure the year, month, and day values, you can:
  • Use constant value calculations.
  • Extract the value from a date in Workday using a date extract calculation.
Conditional Calculation
Returns a date based on if statements.
If payment date is between 2020-07-01 and 2020-12-31, then fiscal year-end date = 2021-06-30.
You must use an instance set comparison calculation, instance value calculation, logic calculation, or value comparison calculation as the condition.
When you configure multiple conditions, Workday:
  • Uses the first condition that is True.
  • Reorders the rows according to the values in the
    Order
     field after you save the calculation.
Constant Date Calculation
Returns a defined constant date.
  • Define a constant date of 2021-07-01 to use in other calculations.
  • Calculate actual load statuses as of a constant date calculation instead of the actual enrollment usage start date.
Name the calculation after the date value to make it easier to find. Example:
2021-07-01
.
Date Increment/Decrement Calculation
Starts with a date and adds or subtracts years, months, or days to return another date.
Add 30 days to the worker or student's start date.
You can use instance value calculations, conditional calculations, build date calculations, or constant date calculations in date increment/decrement calculations.
Instance Value Calculation (Date)
A calculation that returns a date. In addition to a date, it can also return currency, and boolean attributes.
  • Workday-delivered IVCs return dates based on report fields.
  • Customer-owned IVCs return dates based on custom fields.
Return the current period start date or period end date.
Return the worker's hire date, termination date, or continuous service date.
You can use the
All Instance Value Calculations
 report to access a list of available IVCs and view details about each calculation, such as:
  • The report field or custom field that the IVC is based on and its business object.
  • Any comments that describe the type of data that the IVC returns.
  • Related instances of the IVC.
Date Difference
 and
Date Extract
 calculations, while related to dates, return a numeric value.