Features used to implement the example

• Calculated Text Field

Example: Setting Calculated Text Field depending on custom fields

In this example the value of a calculated text field get's set by evaluating 2 other date picker custom fields.

For this example the following custom fields are needed:

• Date Picker custom field "Date closed"
• Date Picker custom field "Expected Due Date"

The Calculated Text Field should be set on 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" }

The configuration will look like this:

Text to be parsed is: {10423} != null ? ({10423} <= {10424} ? "Yes" : "No") : (datePart({000057}, LOCAL) > {10424} ? "No" : null)

Note that:

• {10423} is field code for custom date picker "Date closed" (your code might be different)
• {10424} is field code for custom date picker "Expected Due Date" (your code might be different)