|
Operator
|
Date Fields
|
Number Fields
|
Text Fields
|
Enumerated Types
|
|
between
|
X (default)
|
|||
|
null
|
X
|
X
|
X
|
X
|
|
not null
|
X
|
X
|
X
|
X
|
|
yesterday
|
X
|
|||
|
last week
|
X
|
|||
|
last month
|
X
|
|||
|
last quarter
|
X
|
|||
|
last year
|
X
|
|||
|
today
|
X
|
|||
|
this week
|
X
|
|||
|
this month
|
X
|
|||
|
this quarter
|
X
|
|||
|
this year
|
X
|
|||
|
tomorrow
|
X
|
|||
|
next week
|
X
|
|||
|
next month
|
X
|
|||
|
next quarter
|
X
|
|||
|
next year
|
X
|
|||
|
equals
|
X
|
X (default)
|
X
|
X (default)
|
|
not
|
X
|
X
|
X
|
X
|
|
like
|
X (default)
|
|||
|
not like
|
X
|
|||
|
in
|
X
|
X
|
||
|
not in
|
X
|
X
|
||
|
>
|
X
|
X
|
X
|
|
|
>=
|
X
|
X
|
X
|
|
|
<
|
X
|
X
|
X
|
|
|
<=
|
X
|
X
|
X
|