How to find historical issue counts in Jira?

[Dutta, Kunal]

Hello Team,

I'm looking forward to find the number of bugs/issues which were created and were existing on a particular day in past?

For example:-

I want to know, how many bugs (either in Open or In Progress state) were existing on 04th September 2021?

Tried using the following JQL

 #1

type in (Bug, EBF) AND status in (Open, "In Progress") AND created <= 2021-09-04

#2

type in (Bug, EBF) AND status was not in (Resolved, Closed) ON "2021-09-04" AND created <="2021-09-04"

#3

(type in (Bug, EBF) AND status in (Open, "In Progress") AND created >= 2021-09-04)

I tried taking the difference of #1 & #3 to find the exact number of bugs count as on 4th September 2021, however yet to get exact number.

Appreciate your response.

Thanks in Advance. 

[Trudy Claspill]

Try this:

type in (Bug, EBF) and createddate <= 2021-09-04 and resolutiondate >= 2021-09-05