How to filter blocks by scheduled date?

[Gabriel_Augusto]

I have this code but isn’t returning result.

What is wrong and how can I sort blocks by scheduled date?

#+BEGIN_QUERY
{:title [:b “Tarefas Recorrentes”]
:query [:find (pull ?b [*])
:in $ ?day ?next5
:where
[?p :block/name “tarefas recorrentes”]
[?b :block/page ?p]
[?b :block/scheduled ?d]
(between ?d ?day ?next5)
]
:inputs [:today :+5d]
}
#+END_QUERY

Thanks

[mentaloid]

• About what is wrong:
  • The first argument of between expects a block.
  • Try instead this:

    [(>= ?d ?day)]
    [(<= ?d ?next5)]
    

• Concerning sorting: Sort deadline query chronologically

[Gabriel_Augusto]

@mentaloid

[(>= ?d ?day)]
[(<= ?d ?next5)]

Thankss, you are the guy <3