Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Increment or Decrement Date

Increment or Decrement Date

  • Create the numeric constants you want to use in the calculated field.
  • Security:
    Custom Field Management
     domain in the System functional area.
You can use the calculated field to compute a date that's a specific number of days, months, or years before or after the date field. You can also add or subtract time to or from a date field that captures time data.
  1. Access the
    Create Calculated Field
     task.
  2. Select
    Increment or Decrement Date
     from the
    Function
     prompt.
  3. On the
    Calculation
     tab, select an option from the
    Date Field
     prompt to use as the starting date.
    To enable time, specify a date field that includes a time component.
  4. (Optional) Select options from these prompts to specify the date or time to add to or subtract from the
    Date Field
    :
    • Years to Add or Subtract
    • Months to Add or Subtract
    • Days to Add or Subtract
    • Hours to Add or Subtract
    • Minutes to Add or Subtract
    • Seconds to Add or Subtract
    • Milliseconds to Add or Subtract
    Time prompts are available only for date fields that include a time component.
  5. (Optional) Select the
    Return Blank Date on Error
     check box to return a blank value instead of an error message when the calculated field returns a blank value.
    If you use a Prism business object with this calculated field, Workday always returns a blank value regardless of your check box selection.
You can use the calculated field to:
  • Calculate 2 months from now for use in a report filter that selects employee certifications expiring in the next 2 months.
  • Calculate the end of an employee's 6-month probationary period based on the hire date.
  • Look up the prior value of a field by subtracting 1 millisecond from when a business process event ran.
You can create:
  • Additional calculated fields.
  • New calculated fields from within an increment or decrement date calculated field.