---
title: "Calculated field, ChatGPT: the full transcript — Kiweely"
description: "Every turn of ChatGPT 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-cg
---

# T1 · CG · ChatGPT: OpenAI GPT-6.2 Astra (reasoning high) via Codex CLI

## Turn 1: prompt (sent 2026-11-20T04:46:21.084Z)

In our Workday tenant I need a calculated field on Worker called “Service Band TT-GPT” 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 give me what I need to build it.

## Turn 1: answer (2026-11-20T04:46:50.370Z, 29.3 s)

I’ll check the Workday calculated-field names and how to set up the anniversary boundaries, then give you the build steps and test cases.

Use **Create Calculated Field** to build **Service Band TT-GPT** as a reusable **Worker** field. Its function is **Evaluate Expression** and its return type is **Text**.

1.  **Choose the service start date.** On Worker, create a **True/False Condition** that tests whether `Continuous Service Date` **is not empty**. Then create `Service Start Date TT-GPT` as an **Evaluate Expression** with field type **Date**. Set its **Default Value** to `Hire Date`. Add one condition row that returns `Continuous Service Date` when the condition is true. [Workday Evaluate Expression guide](https://doc.workday.com/admin-guide/en-us/manage-workday/tenant-configuration/calculated-fields/calculated-field-functions/dan1370796323223.html)
    
2.  **Calculate completed years.** On Worker, create `Completed Service Years TT-GPT` using **Date Difference**. Set **Start Date Field** to `Service Start Date TT-GPT`, **End Date Field** to the dynamic `Today` field, and the unit to **In Years**. Leave **Ignore Lower Level Date Components** unchecked so Workday counts the month and day and advances the year count on the anniversary. If both source dates can be blank, this design assumes those workers should receive `Under 1 year` to keep the output within your four labels. Select **Return Zero on Error** for that behavior. [Workday Date Difference guide](https://doc.workday.com/admin-guide/en-us/manage-workday/tenant-configuration/calculated-fields/calculated-field-functions/dan1370796334664.html)
    
3.  **Assign the band.** Create three Worker **True/False Condition** fields comparing `Completed Service Years TT-GPT` to the numeric values below. Create or reuse a **Global Text Constant** for each of the four exact labels. In **Service Band TT-GPT**, select those constants as the return values and enter the rows in the order shown. Workday returns the first true row. [Workday calculated fields guide](https://doc.workday.com/workday-education/en-us/course-manuals/workday-reporting/calculated-fields.html?toc=5)
    

| Evaluation order | Condition | Text to return |
| --- | --- | --- |
| 1 | Completed service years ≥ 5 | `5 years or more` |
| 2 | Completed service years ≥ 3 | `3 to 5 years` |
| 3 | Completed service years ≥ 1 | `1 to 3 years` |
| Default Value | No row matched | `Under 1 year` |

**Report check.** Add `Service Band TT-GPT` as a column on a Worker custom report. A worker one day short of their third anniversary should show `1 to 3 years`. On the anniversary, they should show `3 to 5 years`. For a worker with a blank Continuous Service Date, verify the same transition against their Hire Date.

## Turn 2: follow-up (sent 2026-11-20T04:52:49.284Z)

Step 1 says to create a True/False Condition on Worker that tests whether Continuous Service Date “is not empty”. In Create Calculated Field - True/False Condition, I chose Field = Continuous Service Date. The Operator list has no “is not empty” (typing it shows “No matches found”). The operator list under All shows: is blank, is not blank, equal to, not equal to, greater than, greater than or equal to, less than, less than or equal to.

## Turn 2: answer (2026-11-20T04:52:54.719Z, 5.4 s)

Choose **is not blank**. My earlier wording, “is not empty,” was incorrect for your screen. This operator checks the date field directly, so leave the comparison value empty.

Save the True/False Condition and use it as the sole row in `Service Start Date TT-GPT`. Set **Return Value If Condition is True** to `Continuous Service Date` and **Default Value** to `Hire Date`.
