You are here:
Filter Operators
Filter operators are used when creating filters in calculated fields.
These operators are currently supported:
- Equals
- Does Not Equal
- Between
- Less than
- Less than or equal to
- Greater than
- Greater than or equal to
- Is Empty
- Is not Empty
- Contains
- Contains (Ignore Case)
- Not Contains
- Not Contains (Ignore Case)
- Starts With
- Starts With (Ignore Case)
- Does Not Start With
- Does Not Start With (Ignore Case)
- Does Not End With
- Does Not End With (Ignore Case)
- Is Null
- Is Not Null
Valid operators for date/datetime:
- Fiscal Year—Current Fiscal Year, Previous Fiscal Year, Next Fiscal Year, Current Fiscal Year To Date, Previous Fiscal Year To Date
- Fiscal Quarter—Current Fiscal Quarter, Previous Fiscal Quarter, Next Fiscal Quarter, Current Fiscal Quarter To Date, Previous Fiscal Quarter To Date
- Calendar Year—Current Year, Previous Year, Next Year, Current Year To Date, Previous Year To Date
- Calendar Quarter—Current Quarter, Previous Quarter, Next Quarter, Current Quarter To Date, Previous Quarter To Date
- Calendar Month—Current Month, Previous Month, Next Month, Current Month To Date, Previous Month To Date
- Calendar Week—Current Week, Previous Week, Next Week
- Day—Last 7 Days, Last 30 Days, Last 90 Days, Last 180 Days, Next 7 Days, Next 30 Days, Next 90 Days, Next 180 Days
Did this article solve your issue?
Let us know so we can improve!
