Jira JQL Query for Issues resolved today / Jira Query for issues resolved Yesterday

[Michael Green]

Hi,

I'm looking for the best JQL for 2 different queries:

1. Jira JQL Query for Issues resolved today 

2. Jira Query for issues resolved Yesterday

The best I've been able to find is something like :

project =IDYOUS and resolutiondate >= -1d ORDER BY KEY ASC

Is there no function in JQL for Today() or Yesterday()

I want to ensure I'm using the dates and NOT just taking 24 hours off the resolved date / time.

What is the best JQL to use ?

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Michael Green 

As @Sri Kumar very well guided you on these specific JQL functions, I'll provide your queries

1. resolutiondate >= startOfDay()
2. resolutiondate >= startOfDay(-1) and resolutiondate <= endOfDay(-1)

Regards,
Alex

[Michael Green]

Thanks Alex !  Will give that a try !

[Sri Kumar]

Hi @Michael Green

Welcome to the Atlassian community. We understand that you are looking for JQL functions that can help you get Issues resolved Today and Yesterday. 

I was able to find the below function from Advanced search reference - JQL functions 

• endOfDay()

Could you please check the above function and check if you are getting desired results? 

Regards,
Sri