Skip to content
KiweelyKiweelyKiweely

T1 · CL · Claude: Anthropic Claude Opus 5.5 (effort high) via Claude Code 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-CLA” 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:47:03.209Z, 42.1 s)

I couldn’t test this in your tenant, so it’s a build spec. It uses only standard calculated field functions and needs 9 fields, all on the Worker business object. Build them in order, because each field uses the ones before it.

Design choice: I compare today against the 1st, 3rd and 5th anniversaries of the service start date. I didn’t use Date Difference in Years, because the way it rounds partial years is easy to misread. With the anniversary test, a worker with exactly 1, 3 or 5 completed years always lands in the higher band.


Step 1: Choose the start date

1. CF TT-CLA Has Continuous Service Date

  • Function: True/False Condition
  • Condition: Field = Continuous Service Date, Operator = is not blank

2. CF TT-CLA Service Start Date

  • Function: Evaluate Expression, Return type: Date
  • Row 1: Condition = CF TT-CLA Has Continuous Service Date → Value from field Continuous Service Date
  • Default: Value from field Hire Date

Step 2: Calculate the anniversaries

All three use Increment or Decrement Date with Date = CF TT-CLA Service Start Date, Operation = Increment, Unit = Years.

# Field name Quantity
#3 Field nameCF TT-CLA 1st Anniversary Quantity1
#4 Field nameCF TT-CLA 3rd Anniversary Quantity3
#5 Field nameCF TT-CLA 5th Anniversary Quantity5

Step 3: Check whether each anniversary has passed

All three use True/False Condition. Operator = less than or equal to, comparison type = Value from Another Field, compared field = Today. Today is a global field, so it’s always available.

# Field name Field
#6 Field nameCF TT-CLA Reached 1 Year FieldCF TT-CLA 1st Anniversary
#7 Field nameCF TT-CLA Reached 3 Years FieldCF TT-CLA 3rd Anniversary
#8 Field nameCF TT-CLA Reached 5 Years FieldCF TT-CLA 5th Anniversary

“Less than or equal to” is what makes the anniversary day itself count, which puts exactly 1, 3 or 5 years in the higher band.

Step 4: The field for reports

9. Service Band TT-CLA

  • Function: Evaluate Expression, Return type: Text
  • The rows must be in this order, because the first true condition wins:
Order Condition Value (text)
Order1 ConditionCF TT-CLA Reached 5 Years Value (text)5 years or more
Order2 ConditionCF TT-CLA Reached 3 Years Value (text)3 to 5 years
Order3 ConditionCF TT-CLA Reached 1 Year Value (text)1 to 3 years
OrderDefault Condition— Value (text)Under 1 year

Test cases (today = 2026-11-19)

Continuous Service Date Hire Date Expected
Continuous Service Date2025-11-20 Hire Date— ExpectedUnder 1 year
Continuous Service Date2025-11-19 Hire Date— Expected1 to 3 years
Continuous Service Date2023-11-20 Hire Date— Expected1 to 3 years
Continuous Service Date2023-11-19 Hire Date— Expected3 to 5 years
Continuous Service Date2021-11-20 Hire Date— Expected3 to 5 years
Continuous Service Date2021-11-19 Hire Date— Expected5 years or more
Continuous Service Date(blank) Hire Date2020-01-01 Expected5 years or more
Continuous Service Date2025-06-01 Hire Date2018-03-01 ExpectedUnder 1 year (Continuous Service Date takes priority)

The quickest check is a simple custom report on All Workers. Include Continuous Service Date, Hire Date, CF TT-CLA Service Start Date, the three anniversary fields and Service Band TT-CLA. Then pick workers whose dates fall on or right next to the boundaries.

Edge cases you may want to decide on

  • Both dates blank: this shouldn’t happen for a worker with a hire, but it would return “Under 1 year”. If you’d rather leave the band empty, add a True/False check for “Start Date is blank” as row 0 and make it return a blank value.
  • Future-dated hires: these return “Under 1 year”.
  • Terminated workers: service keeps counting up to today, which is what you asked for. If you want it to stop at the termination date, change the field Step 3 compares against to an Evaluate Expression that returns the termination date if there is one and Today if not.
  • Feb 29 start dates: check how your tenant adds years to Feb 29. It usually lands on Feb 28 in non-leap years, which would move that worker into the next band one day early.
  • Security: a calculated field is secured by the fields it reads. Report users need access to the domain that secures service dates and hire dates, or they’ll see blanks.

Turn 2: follow-up (sent 2026-11-20T05:11:08.319Z)

Steps 1 to 8 are built and saved. At Step 4, field 9 (Evaluate Expression, Return type Text), the Default Value box and the “Return Value If Condition is True” box are prompts that only accept an existing Workday field (a search list); typing “Under 1 year” and pressing Enter just searches existing fields and lists these three results: “Band Label Under 1 year TT-GPT”, “CF TC - Under 1 year - TT-GEM”, “CF TC Service Band Under 1 Year TT-GE”. There is no box to type literal text. The prompt’s menu also offers the categories By Category, All, Global Fields, Other, and “Create Calculated Field”. Step 4 says Value (text) = 5 years or more, 3 to 5 years, 1 to 3 years and default Under 1 year, but no field with exactly those values exists for me to pick. How do I enter these text values?

Turn 2: answer (2026-11-20T05:11:20.683Z, 12.4 s)

That one’s on me: Step 4 should have told you to create the text values first. In Evaluate Expression, the condition and the return values both have to be fields. You can’t type text straight into those boxes. The usual fix is to make one small Text Constant calculated field for each label.

Step 3b: Create four Text Constant fields

Use the Create Calculated Field task. You can also use the “Create Calculated Field” option in that prompt’s menu, but the separate task is easier because you don’t leave field 9 half-finished.

For each one, set Business Object = Worker, Function = Text Constant and Field Type = Text, then type the value in the Text Constant box:

# Field name Text Constant value
#9a Field nameCF TT-CLA Text Under 1 Year Text Constant valueUnder 1 year
#9b Field nameCF TT-CLA Text 1 to 3 Years Text Constant value1 to 3 years
#9c Field nameCF TT-CLA Text 3 to 5 Years Text Constant value3 to 5 years
#9d Field nameCF TT-CLA Text 5 Years or More Text Constant value5 years or more

Type the values exactly as shown, including the lowercase letters. Make sure there’s no space at the start or end, because reports and filters will match on this exact text.

Then finish field 9

In Service Band TT-CLA, type TT-CLA Text in each prompt to find your new fields:

Order Condition Return Value If Condition is True
Order1 ConditionCF TT-CLA Reached 5 Years Return Value If Condition is TrueCF TT-CLA Text 5 Years or More
Order2 ConditionCF TT-CLA Reached 3 Years Return Value If Condition is TrueCF TT-CLA Text 3 to 5 Years
Order3 ConditionCF TT-CLA Reached 1 Year Return Value If Condition is TrueCF TT-CLA Text 1 to 3 Years
OrderDefault Value Condition— Return Value If Condition is TrueCF TT-CLA Text Under 1 Year

Don’t use the three fields that already exist

The fields that showed up in your search (“…TT-GPT”, “…TT-GEM”, “…TT-GE”) belong to other builds. Someone else could change or delete them, and their wording may not match yours exactly. Creating your own four fields keeps this build self-contained.

When it’s saved, run the test report from before and check the boundary cases. In particular, check that a start date of 2023-11-19 shows “3 to 5 years”.