Accessing Jira Content depending on certain time stamp (time limit)

[Sindhu Rashmi]

Hello Everybody,

I am trying get all the issues based on the criteria like  Project Name, status=Open OR Close and issue reported between the two dates.   

I have tried various queries to get the desired result. Following is the query I tried to retrieve the needed information:

https://companySpecficHost/rest/api/2/search?jql=project=XXXXID&status%20in%20(Open)&created%20>=%20"2019-02-25T17:10:06"%20AND%20created%20<=%20"2019-02-26T17:10:06"

I have tried different formats of dates including only date part after removing time part.

With above queries, I successfully retrieve the project specific issues but other two filter are not working as expected:

1. First issue, It is not able to fetch all the created issues between two dates:

For example: Filter on %20created%20>=%20"2019-02-25T17:10:06"%20AND%20created%20<=%20"2019-02-26T17:10:06”

It returned all the issues including different dates like   "created": "2019-02-27T17:10:06.000+0200" , “created": "2019-02-20T12:38:11.000+0200", even some entries for 2014 etc..

1. Filter for status = Open and Closed: I see it retrieves “In Progress” and “Resolved” also.

I tried various combination but always ended up in same result.  I am new to using the jira API and JQL. Right now, none of the combination is working. Can someone help me out here?

Thanks in advance.