Expression Operators
An operator performs an operation in an expression on one or more elements that hold value.
The following table describes the operators that can be used to build your expressions:
| Symbol | Description | Example | Supported Date Types (non-numeric & non-boolean) |
|---|---|---|---|
| + | add/concatenate | A + B |
string+string=string date+time=date time+time=time |
| - | subtract/negate | A - B or -A |
date-date=time date-date=date time-time=time -time=time |
| * | multiply | A * B | N/A |
| / | divide | A / B | N/A |
| == | is equal to* | A == B |
string==string date==date time==time |
| != | is not equal to* | A != B |
string!=string date!=date time!=time |
| < | less than* | A < B |
string<string date<date time<time |
| <= | less than or equal to* | A <= B |
string<=string date<=date time<=time |
| > | greater than* | A > B |
string>string date>date time>time |
| >= | greater than or equal to* | A >= B |
string>=string date>=date time>=time |
| ! | logical NOT | A ! B | N/A |
| && | logical AND | A && B | N/A |
| || | logical OR | A || B | N/A |
| | | bitwise inclusive OR | A | B | N/A |
| !& | bitwise exclusive OR | A !& B | N/A |
| & | bitwise AND | A & B | N/A |
| ^ | power (exponent) | A ^ B | N/A |
| % | modulus (remainder) | A % B | N/A |
* Comparison operators are not case sensitive. For case sensitive comparisons, use the function IsStringEqual.