JQL query return Incorrect data

Tehmina Aslam_cedkdc

Hi,

I want to get the issues updated or created yesterday in Jira; today is January 16. I have added a query. 

project = "Jeeny Reboot" AND (created < endOfDay(-1) OR updated < endOfDay(-1))

 But the query returns me the issue created or updated by today or even created or updated by the 12th of January. Why is this happening? 

 

Thanks in advance,

Walter Buggenhout

Hi @Tehmina Aslam,

You'll need to add the start of the day as well in order to restrict your search to just yesterday. Try the following instead:

project = "Jeeny Reboot" AND
((created >= startOfDay(-1) AND created <= endOfDay(-1)) OR
(updated >= startOfDay(-1) AND updated <= endOfDay(-1)))

 Hope this helps!