Comparison Operators

The following table describes the purpose of each comparison operator, and gives an example of how it is used.

Operator Purpose Example

=

Equality Text

[Publish External] = “Y"

>

Inequality text

[Role] > LookupValue (“ROLE_TYPE", “Manager")

>

Greater than

[Start Date] > Today()

Less than

[End Date] Today() + 4

>=

Greater than or equal to

[Start Date] >= Today()

=

Less than or equal to

[End Date] = Today() - 4

Note: The last four operators are used only for Date fields.