Operators are the factors that decide whether or not a condition evaluates as true. Each data type will only have the operators appropriate to its circumstances.
| Data Types | Data Types | Data Types | Data Types | Data Types |
|
Operator | Expression | Logic | Date | Numerical | String | Description |
Ending With |
|
|
|
| ✔ | If the value being checked ends with the value being checked against, the condition is true. |
Beginning With |
|
|
|
| ✔ | If the value being checked begins with the value being checked against, the condition is true. |
Not Containing |
|
|
|
| ✔ | If the value being checked does not contain the value being checked against, the condition is true. |
Containing |
|
|
|
| ✔ | If the value being checked contains the second value, the condition is true. |
Less than or Equal to | ✔ |
| ✔ | ✔ |
| If the value being checked is less than or equal to the value being checked against, the condition is true. |
Less Than | ✔ |
| ✔ | ✔ |
| If the value being checked is less than the value being checked against, the condition is true. |
Greater Than or Equal to | ✔ |
| ✔ | ✔ |
| If the value being checked is greater than or equal to the value being checked against, the condition is true. |
Greater Than | ✔ |
| ✔ | ✔ |
| If the value being checked is greater, then the condition is true. |
Not Between | ✔ |
| ✔ | ✔ |
| If the value being checked is not in the range entered, the condition is true. |
Between | ✔ |
| ✔ | ✔ |
| If the value being checked is in the range entered, the condition is true. |
Not Equal to | ✔ | ✔ | ✔ | ✔ | ✔ | If the compared values are not equal, the condition is true. |
Equal to | ✔ | ✔ | ✔ | ✔ | ✔ | If the compared values are equal, the condition is true. |