...
Basic | Like with numeric fields, you can do different comparisons:
Important:
| ||||
Date formats | Formats that are supported are:
Note: Partial date/times are automatically expanded. Example: "2018" is converted to 2018-01-01 00:00 | ||||
Null values | Find null values with fields that are nullable:
| ||||
Filter day or month | All deadlines on a day (UTC):
All deadlines in a month (UTC):
| ||||
Date offsets | Sometimes it is easier to filter by a date offset. For example: Find jobs with a deadline of tomorrow. This can be expressed with "1d". More examples:
You can thus use one or more combinations of:
Deadline within +/- 6 hours:
All objects created since 1 year and 6 months:
|
Boolean filtering
Basic | Valid examples:
Permitted operators are: "=" and "!=".
|
...