Comparable fields

Field comparison supports the comparison of several fields.

The types of fields that are comparable include the following.
  • String, choice, integer, and boolean fields: return true if both values match.
  • Reference fields: return true if both reference fields refer to the same record.
  • Date and time fields: can match date values based on hour, day, week, month, quarter, or year. Additionally, you can evaluate whether two dates fall within a certain range of each other.
Note: Field comparison does not support journal, keyword, script, duration, list, or HTML fields.