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.
Choose the service start date. On Worker, create a True/False Condition that tests whether
Continuous Service Dateis not empty. Then createService Start Date TT-GPTas an Evaluate Expression with field type Date. Set its Default Value toHire Date. Add one condition row that returnsContinuous Service Datewhen the condition is true. Workday Evaluate Expression guideCalculate completed years. On Worker, create
Completed Service Years TT-GPTusing Date Difference. Set Start Date Field toService Start Date TT-GPT, End Date Field to the dynamicTodayfield, 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 receiveUnder 1 yearto keep the output within your four labels. Select Return Zero on Error for that behavior. Workday Date Difference guideAssign the band. Create three Worker True/False Condition fields comparing
Completed Service Years TT-GPTto 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.