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?
Please try:
last week
due >= startOfWeek(-1w) and due <= startOfWeek()
next week
due >= endOfWeek(1w) and due <= endOfWeek(2w)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.