Question regarding date "windows" in org-ql
I want to add a section to my agenda that contains only items with a single (sales items), and which are not DONE, and which have a scheduled date within a given time horizon.
It SEEMS like I ought to be able to do this with org-ql, but I'm having trouble making it work.
The section is currently coded like this:
(org-ql-block
'(and
(todo)
(tags "Sales" :inherit t)
(ts: from -999 :to 14)
((org-ql-block-header "Sales Items")))
I tried to do this with a regular agenda block, and got nowhere. Using tags-todo doesn't work as well, bc I need to see the timing.
What I get NOW is "any non-Done items with the Sales tag that are scheduled in the future," so reminder items about touching base with client X in 45 days ALSO show along with the things I need to have on my mind this week, so that's less than optimal.
It SEEMS like this should be doable, but maybe I'm missing something.
I'm on a Mac, running emacs 30.2 and orgmode 9.8.6. I installed org-ql from melpa today, so it oughta be current as well.
Help?