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

Build Date

Security:
Custom Field Management
 domain in the System functional area.
You can use the calculated field to create a new date or time field that uses components from other fields or specified values. By using the different date and time components, you can create a date field based on the:
  • Day
  • Month
  • Year
You can create a time field based on these components that includes the time and time zone:
  • Hour
  • Minute
  • Second
  • Millisecond
  1. Access the
    Create Calculated Field
     task.
  2. Select
    Build Date
     from the
    Function
     prompt.
  3. On the
    Calculation
     tab, select a value from the
    Field Type
     prompt.
  4. As you complete the task for date field types, consider:
    Option
    Description
    Specific Year
    Specific Month
    Specific Day
    Specify a value or use a value from a field.
    Extract Year from Date Field
    Extract Month from Date Field
    Extract Day from Date Field
    Select to extract the day, month, or year from a date field.
  5. As you complete the task for time field types, consider:
    Option
    Description
    Specific Hour
    Specific Minute
    Specific Second
    Specific Millisecond
    Enter an integer.
    If you enter zero for
    Specific Second
    , Workday changes zero to
    None of the above
     when you save the calculated field. This change doesn't impact the report results.
    Extract Hour from Date/Time Field
    Extract Minute from Date/Time Field
    Extract Second from Date/Time Field
    Extract Millisecond from Date/Time Field
    Select to extract the hour, minute, second, or millisecond from a field that includes time.
    User's Timezone
    (Available when you select the
    DateTimeZone
    Field Type
    .) Click to enable Workday to use the report runner's locale to determine the time zone.
    Although you enter the time values on a 24-hour clock, Workday displays the time as a 12-hour clock.
    Value Entered
    Displayed Value
    Hour:
    0
    Minute:
    1
    12:01 AM
    Hour:
    1
    Minute:
    30
    01:30 AM
    Hour:
    12
    Minute:
    1
    12:01 PM
    Hour:
    13
    Minute:
    30
    01:30 PM
  6. (Optional) Select the
    Return Blank Date on Error
     check box to have Workday return a blank value rather than generating an error message when the report runs.
    If you use a Prism business object with this calculated field, Workday always returns a blank value on error regardless of your check box selection.
You can use the build date calculated field to determine the first day of the month when a company hired an employee. Using the Worker business object, select:
  • Date
     as the
    Field Type
    .
  • Hire Date
     as the
    Extract Year from Date Field
    .
  • Hire Date
     as the
    Extract Month from Date Field
    .
  • 1
     as the
    Specific Day
    .
You can add your build date calculated field to a custom report to display the results. Example: For an employee hired on 2006-02-17, Workday displays the build date field as 2/1/2006.
You can create:
  • Additional calculated fields.
  • New calculated fields from within a build date calculated field.