Filtering items where "date is greater than a specific date" via the API

The only thing that seems to be close is:

Oops: I read your sentence

after I finished my post. Anyhow, looks like the only way is to “misuse” the second date and search for “between”.

{
  boards(ids: [4048117859]) {
    items_page(
      query_params: {rules: [{column_id: "date4", compare_value: ["2023-02-26", "2999-12-31"], operator: between}]}
    ) {
      cursor
      items {
        id
        name
      }
    }
  }
}

Where the first ISO date is where you want to filter from and the second on is far in the future (who care about the year 3000 problem 🙂). Look like the greater_than operator does not accept an ISO date, just the predefined ones from the documentation

Yeah, using the “between” operator should work with a date far in the future.

I’m curious if this is what monday does internally for board filtering in their board UI (though maybe they’re not using the same public API we’re using).

Hello there,

Can you try using something like this?

{
  boards(ids: [1234567890]) {
    items_page(
      query_params: {rules: [{column_id: "date4", compare_value: ["EXACT", "2023-11-05"], operator: greater_than}]}
    ) {
      cursor
      items {
        id
        name
      }
    }
  }
}

Please let me know how that goes!

Cheers,
Matias

Looks like that works. Thanks!

That would probably be a good thing to add to the documentation here: Date.

Done! Thanks for the suggestion @PluginGenie and solution @Matias.Monday 👏