Skip to content
KiweelyKiweelyKiweely

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

On this page

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

  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

  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

Evaluation order Condition Text to return
Evaluation order1 ConditionCompleted service years ≥ 5 Text to return5 years or more
Evaluation order2 ConditionCompleted service years ≥ 3 Text to return3 to 5 years
Evaluation order3 ConditionCompleted service years ≥ 1 Text to return1 to 3 years
Evaluation orderDefault Value ConditionNo row matched Text to returnUnder 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.