Some APIs allow you to filter your results by date. Filters use the ISO-8601 format, and their values can be either inclusive or exclusive. Square brackets []
specify that a value is inclusive, while round brackets ()
indicate that a value is exclusive.
Inclusive []
: If a value is inclusive, that means it is included in the range. Another way to think about this is like the <=
or =>
operators.
Exclusive ()
: If a value is exclusive, it is not included in the range.These function like the <
and >
operators.
For example:
createdAt=[2021-08-01T13:00:00.000Z,2021-09-01T13:00:00.000Z)
This query is requesting all results that have a createdAt
property anywhere between 2021-08-01T13:00:00.000Z
and 2021-09-01T13:00:00.000Z
, including 2021-08-01T13:00:00.000Z
itself, but excluding 2021-09-01T13:00:00.000Z
.
Currently Orderful only supports:
- Inclusive start date and exclusive end date