I am trying to create a filter that will pick up only issues that are due to be actioned between 20 minutes from now and 10 minutes from now.
There is a date/time field defined that will have been populated with the actioning time (Planned Run Time) and I need the report to pick up only issues that are between 20 and 10 minutes prior to this time
I can get the first part to work
"Planned Run Time" >= -20m
But I thought adding the following would work and it doesn't
AND "Planned Run Time" <= -10m
So my full JQL was "Planned Run Time" >= -20m AND "Planned Run Time" <= -10m
I cant use specific date/times in the JQL as I want to use these filters for subscription notification reporting (so subscribed users get an email with issues that are due to be actioned between 20 and 10 minutes time from the present)
What am I doing wrong?
Thanks