Items_by_column_values query Dates by Range

Hey,

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.

Best Regards,
Laurent, Synolia (monday.com platinum partner)

Hi @LaurentConroux!

Thank you for your feedback on this feature. I agree that this capability would be super helpful to have for our items_by_column_values() method.

I’m going to pass this on as feedback for our team’s consideration. I know that we had plans to implement searching multiple column values, and even perhaps multiple columns this year. Perhaps this will be implemented sooner rather than later!

Thanks~