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