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:

SymbolDescriptionExampleSupported Date Types

(non-numeric & non-boolean)

+add/concatenateA + B

string+string=string

date+time=date

time+time=time

-subtract/negateA - B or -A

date-date=time

date-date=date

time-time=time

-time=time

*multiplyA * BN/A
/divideA / BN/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 NOTA ! BN/A
&&logical ANDA && BN/A
||logical ORA || BN/A
|bitwise inclusive ORA | BN/A
!&bitwise exclusive ORA !& BN/A
&bitwise ANDA & BN/A
^power (exponent)A ^ BN/A
%modulus (remainder)A % BN/A

* Comparison operators are not case sensitive. For case sensitive comparisons, use the function IsStringEqual.