search results for specific date ranges

[fbeck_br]

I have a weekly report every wednesdays.

this report may have two columns:

- last week issues status

- next week issues planning

for the first column I would like to have some query like this:

- All issues assigned to me

AND

- duedate <= startofweek() -5

AND

- duedate > startofweek() -12

Is it possible to perform some operation ( + or -) for startofweek() method ??

Or is there another idea to reach the results I need?

[Jose M. · Accepted solution]

Please try:

last week
due >= startOfWeek(-1w) and due <= startOfWeek()

next week
due >= endOfWeek(1w) and due <= endOfWeek(2w)

[fbeck_br]

Perfect!

thanks!