Recently we had to query items based on a date range and would have love to do it with the items_by_column_value query.
The requests I was asked to make were of two kinds:
- Retrieve items where the date column value was between 2 date values
- Retrieve items where the date column value was between today and N (days|weeks|months|years) ago.
We did code this using multiple successive queries but we would have love to do it in one go with no need to parse the date values.
Laurent, Synolia (monday.com platinum partner)