...
Operator | Choices | Description |
---|---|---|
equals | Single date | Exact date match |
does not equals | Single date | No date match |
less than | Single date | Date is before the date selected on the right side |
less than or equals | Single date | Date is before or equal to the date selected on the right side |
less than (or empty) | Single date | Date is empty or before the date selected on the right side |
less than or equals (or empty) | Single date | Date is empty or before or equal to the date selected on the right side |
greater than | Single date | Date is after the date selected on the right side |
greater than or equals | Single date | Date is after or equal to the date selected on the right side |
greater than (or empty) | Single date | Date is empty or after the date selected on the right side |
greater than or equals (or empty) | Single date | Date is empty or after or equal to the date selected on the right side |
empty | None | All records without a date |
not empty | None | All records with a date |
in time frame | Presets (days ago, next months, etc.) | Defined in picklist |
not in time frame | Presets (days ago, next months, etc.) | Defined in picklist |
is day | Value with presets: days after today, weeks before today) | Defined in picklist. |
is month | Presets (this month, March) | Defined in picklist |
in past | Value with presets: days (on that day), months (in the entire month) | Defined in picklist |
in future | Value with presets: days (on that day), months (in the entire month) | Defined in picklist |
not in past | Value with presets: days (on that day), months (in the entire month) | Defined in picklist |
not in future | Value with presets: days (on that day), months (in the entire month) | Defined in picklist |
- Example operators: