---
title: "Calculated field, Workday’s Agent Chat: the full transcript"
description: "Every turn of Workday’s Agent Chat on the calculated field task in Kiweely’s Workday tenant test, word for word with its times."
url: https://kiweely.com/tenant-test/transcripts/t1-wd
---

# T1 · WD · Workday Self-Service Agent (Agent Chat in the tenant)

## Turn 1: prompt (sent 2026-11-20T04:31:03Z)

In our Workday tenant I need a calculated field on Worker called “Service Band TT-WD” that we can use in custom reports. It should return one of these text values based on completed years of service up to today: “Under 1 year”, “1 to 3 years”, “3 to 5 years”, “5 years or more”. Use the worker’s Continuous Service Date, and if that is blank use their Hire Date. Exactly 1, 3 or 5 completed years belongs to the higher band (so a worker with exactly 3 completed years is “3 to 5 years”). Please build it in our Development tenant.

## Turn 1: answer (read 2026-11-20T04:31:52Z, within 45 s of sending)

I am unable to build calculated fields or perform configuration changes directly in your Workday tenants. This includes creating calculated fields like “Service Band TT-WD” in either your Production or Development tenants, as those administrative capabilities are not supported by my self-service tools.

To create this calculated field, an administrator with the appropriate security access (such as a Report Writer or Configurator) will need to build it manually in Workday. Below are the recommended configuration steps to build this logic:

Recommended Calculated Field Design

To build “Service Band TT-WD” on the Worker business object, you will need to create a chain of calculated fields:

Determine the Service Start Date:

Calculated Field 1: Create an Evaluate Expression (EE) or Coalesce field on the Worker business object. Logic: If Continuous Service Date is not blank, return Continuous Service Date; otherwise, return Hire Date.

Calculate Completed Years of Service:

Calculated Field 2: Create a Determine Interval (DI) field on the Worker business object. Logic: Calculate the interval between the date from Calculated Field 1 (Start Date) and Today’s Date (End Date) in Years.

Determine the Service Band:

Calculated Field 3: Create an Evaluate Expression (EE) field on the Worker business object named “Service Band TT-WD” with a Character default type. Conditions (evaluated in order): First Condition: If Calculated Field 2 (Completed Years) is greater than or equal to 5, return the text constant: “5 years or more” Second Condition: If Calculated Field 2 (Completed Years) is greater than or equal to 3, return the text constant: “3 to 5 years” Third Condition: If Calculated Field 2 (Completed Years) is greater than or equal to 1, return the text constant: “1 to 3 years” Default Value (if none of the above are met): Return the text constant: “Under 1 year”

Note: Evaluating the conditions in descending order (5, then 3, then 1) ensures that exact boundaries (like exactly 3 years) correctly fall into the higher band (“3 to 5 years”) as requested.

Response ready. I am unable to build calculated fields or perform configuration changes directly in your Workday tenants. This includes creating calculated fields like “Service Band TT-WD” in either your Production or Development tenants, as those administrative capabilities are not supported by my self-service tools. To create this calculated field, an administrator with the appropriate security access (such as a Report Writer or Configurator) will need to build it manually in Workday. Below are the recommended configuration steps to build this logic: Recommended Calculated Field Design To build “Service Band TT-WD” on the Worker business object, you will need to create a chain of calculated fields: Determine the Service Start Date: Calculated Field 1: Create an Evaluate Expression (EE) or Coalesce field on the Worker business object. Logic: If Continuous Service Date is not blank, return Continuous Service Date ; otherwise, return Hire Date . Calculate Completed Years of Service: Calculated Field 2: Create a Determine Interval (DI) field on the Worker business object. Logic: Calculate the interval between the date from Calculated Field 1 (Start Date) and Today’s Date (End Date) in Years . Determine the Service Band: Calculated Field 3: Create an Evaluate Expression (EE) field on the Worker business object named “Service Band TT-WD” with a Character default type. Conditions (evaluated in order): First Condition: If Calculated Field 2 (Completed Years) is greater than or equal to 5 , return the text constant: “5 years or more” Second Condition: If Calculated Field 2 (Completed Years) is greater than or equal to 3 , return the text constant: “3 to 5 years” Third Condition: If Calculated Field 2 (Completed Years) is greater than or equal to 1 , return the text constant: “1 to 3 years” Default Value (if none of the above are met): Return the text constant: “Under 1 year” Note: Evaluating the conditions in descending order (5, then 3, then 1) ensures that exact boundaries (like exactly 3 years) correctly fall into the higher band (“3 to 5 years”) as requested. This content was generated by AI. Review before use.

## Note: Agent Chat conversation was gone when reopened

Navigating to the build task closed the panel (Agent Chat button is disabled while the task page is open). The original prompt was re-sent in a NEW conversation at 2026-11-20T04:40:24Z. Its answer differs from turn 1 (same structure; band conditions use < 1, < 3, < 5 with Default ‘5 years or more’; Return Type: Text). Text:

I cannot build or create calculated fields in Workday on your behalf, as I do not have tools that support creating or configuring metadata, custom fields, or calculated fields.

To create this calculated field in your Development tenant, you will need to log in to that tenant and perform the configuration yourself. Here are the logical steps you can follow to build this specific calculated field:

1.  Determine the Date to Use (Evaluate Continuous Service Date vs. Hire Date)

Since you want to use the Continuous Service Date and fall back to the Hire Date if it is blank, you should first create an Evaluate Expression calculated field (or a Coalesce style field if your tenant supports it) to establish the “Effective Start Date”:

Business Object: Worker Function: Evaluate Expression (or Coalesce Date) Logic: If Continuous Service Date is not blank, return Continuous Service Date. Default Value: Hire Date. 2. Calculate Completed Years of Service

Create a Years Service calculated field to determine the number of completed years between your custom “Effective Start Date” (from Step 1) and today:

Business Object: Worker Function: Change Date / Increment Date or Date Difference Logic: Calculate the difference in completed years between your custom “Effective Start Date” and Current Date (today). 3. Map Years to the Service Bands

Create an Evaluate Expression calculated field to return the appropriate text band based on the completed years of service:

Business Object: Worker Field Name: Service Band TT-WD Function: Evaluate Expression Return Type: Text (or a Categorization/Lookup Value if preferred) Conditions (evaluated in order): If Years Service < 1, return “Under 1 year” If Years Service < 3, return “1 to 3 years” If Years Service < 5, return “3 to 5 years” Default Value (representing 5 or more years): “5 years or more”

Note: Because conditions are evaluated in order, a worker with exactly 1 completed year will fail the first condition (< 1) and match the second (< 3), correctly placing them in the “1 to 3 years” band. A worker with exactly 3 years will fall into “3 to 5 years”, and exactly 5 years will fall into the “5 years or more” default.

## Follow-up 1 (sent 2026-11-20T04:42:47Z, new conversation)

In the Evaluate Expression calculated field on Worker (Field Type Date, Default Value Hire Date), the first row has a Condition column that is a prompt. When I type “Continuous Service Date” into it, the prompt shows “No matches found” and offers only: By Category, All, Global Fields, Other, Create Calculated Field. The Field Type list shows: Text, Date, Date Time, DateTimeZone, Time, Numeric, Currency, Boolean.

## Follow-up 1: answer

I cannot access your Workday configuration screens or look up specific tenant metadata on your behalf. However, I can explain why you are seeing this behavior and how to proceed.

The Condition column in an Evaluate Expression calculated field expects a Boolean field (a field that evaluates strictly to true or false) to determine if that row’s logic should execute. It does not accept date or text fields directly.

Because “Continuous Service Date” is a Date field (not a Boolean), Workday filters it out of the search results for the Condition prompt, resulting in “No matches found.”

How to resolve this:

To check if the “Continuous Service Date” is blank or populated, you need to create a helper Boolean calculated field first, and then use that helper field in your Condition column:

Create a Helper Boolean Field:

Task: Create Calculated Field Field Name: something like Continuous Service Date is Not Blank Business Object: Worker Function: True/False Condition Logic: Field: Continuous Service Date Operator: is not empty (or is not blank)

Update your Evaluate Expression Field:

Go back to your Evaluate Expression field. In the Condition column for the first row, search for your new helper field: Continuous Service Date is Not Blank. In the Return Value column for that same row, select the actual date field: Continuous Service Date. Set the Default Value of the Evaluate Expression field to: Hire Date.

## Note: Agent Chat conversation gone again

After the follow-up 1 build attempt the panel was reset again (new conversation, only the greeting). Original prompt re-sent at 2026-11-20T04:54:12Z. Its answer differed again from turn 1; text below. Its step 2 already says Date Difference, so follow-up 2’s complaint about Determine Interval referred to turn 1’s wording (“Determine Interval (DI)”).

I cannot create or build calculated fields in your Workday tenant on your behalf, as I do not have direct administrative or configuration access to the system metadata.

To create this calculated field yourself, you can navigate to the Create Calculated Field task in your Workday Development tenant. Here are the configuration steps to build this field:

1.  Create the Base Date Field (if needed)

First, you will want to determine the effective date to calculate the service years. You need to return the Continuous Service Date, or fall back to the Hire Date if it is blank.

Task: Create Calculated Field Field Name: CF\_Determine\_Service\_Calculation\_Date (or similar naming convention) Business Object: Worker Function: Evaluate Expression (EE) Default Value: Hire Date (built-in Workday field) Condition 1: Continuous Service Date is not blank $\\rightarrow$ Return Value: Continuous Service Date 2. Calculate Completed Years of Service

Next, calculate the number of completed years between that date and today.

Task: Create Calculated Field Field Name: CF\_Completed\_Years\_of\_Service Business Object: Worker Function: Evaluate Expression (EE) or Date Difference (DD) Function Type: Date Difference (DD) From Date: CF\_Determine\_Service\_Calculation\_Date (the field created in Step 1) To Date: Today (built-in system variable) Interval: Years (Completed) 3. Create the Service Band Text Field

Finally, group the completed years into your required service bands.

Task: Create Calculated Field Field Name: Service Band TT-WD Business Object: Worker Function: Evaluate Expression (EE) Return Value Type: Text Conditions: Condition: CF\_Completed\_Years\_of\_Service < 1 $\\rightarrow$ Value: Under 1 year Condition: CF\_Completed\_Years\_of\_Service < 3 $\\rightarrow$ Value: 1 to 3 years Condition: CF\_Completed\_Years\_of\_Service < 5 $\\rightarrow$ Value: 3 to 5 years Default Value: 5 years or more (This covers exactly 5 or more completed years)

Note: By using the strict “less than” (<) operator in order, a worker with exactly 1 completed year will bypass the first condition and fall into the 1 to 3 years band. A worker with exactly 3 completed years will bypass the first two conditions and fall into the 3 to 5 years band, matching your business logic.

## Follow-up 2 (sent 2026-11-20T04:55:15Z, same new conversation)

Step 2 says to create a Determine Interval (DI) field on the Worker business object. In Create Calculated Field with Business Object Worker, typing “Determine Interval” in the Function prompt shows “No matches found”. The function list shows, among others: Aggregate Related Instances, Arithmetic Calculation, Build Date, Concatenate Text, Convert Currency, Convert Text To Number, Count Related Instances, Date Constant, Date Difference, Evaluate Expression, Evaluate Expression Band.

## Follow-up 2: answer

I apologize for the confusion in my previous explanation. The correct Workday function to calculate the time elapsed between two dates is Date Difference, not Determine Interval.

To configure this step in Workday, please use the following settings:

Corrected Step 2: Calculate Completed Years of Service Task: Create Calculated Field Field Name: CF\_Completed\_Years\_of\_Service Business Object: Worker Function: Select Date Difference from the dropdown list. Configuration: From Date: Select CF\_Determine\_Service\_Calculation\_Date (the Evaluate Expression field built in Step 1) To Date: Select the system field for Today (or Current Date) Interval: Select Years Round/Truncate: Select Truncate (or ensure it is configured to return only fully completed years as integers)
