Use case
In this example, the timeliness of an issue is displayed using a calculated text field.
Configuration
Create a new Calculated Text Field (by JWT) custom field and name it properly.
Providing a description will help you to identify what the custom field does but this step is optional
Parser expression
Set the Parsing Mode to Advanced
Add the following expression:
{10423} != null ? ({10423} <= {10424} ? "Yes" : "No") : (datePart({000057}, LOCAL) > {10424} ? "No" : null)
Set the Calculated Text Field to two additional date picker custom fields:
- Date Picker custom field "Date closed"
- Date Picker custom field "Expected Due Date"
Set the display value with the following conditions:
if (Date closed = null && Current Day <= Expected Due Date) { "" } if (Date closed <= Expected Due Date) { "Yes" } if (Date closed > Expected Due Date || (Date closed = null && Current Day > Expected Due Date)) { "No" }
If you still have questions, feel free to refer to our support team.