how to write query to serch issues in the Date range?

[Dipti Pandya]

I could not find any results while i used week or issues between date1 to Date 2 results.

[Thomas B]

Hello @Dipti Pandya - to find issues between certain dates, you can use this query:

created > 2020-04-01 and created < 2020-04-05

updated > 2020-04-01 and updated < 2020-04-09

resolutiondate > 2020-01-01 and resolutiondate < 2020-04-09

You can change the field you want to search by. If you are trying to locate specific issues based on projects or users, you will need to enhance this query. For additional information on jql, see here: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

Thanks!

[Dipti Pandya]

Hi @Thomas B 

thank you for your prompt response and that was very useful to correct my mistake of putting / as separator in Date format. it's working now.

Regards

Dipti

[Thomas B]

Great @Dipti Pandya , glad we could help. If you have additional questions, feel free to create a new post! Have a great day. 

[Dipti Pandya]

@Thomas B 

Actually, i am also struggling to draw issues for which i am not as reporter or assignee but just the updater. so in the quesry if i want to get all such issues that i worked on by adding updates(comments), what would be the best command to get that. i used,

Comment ~ currentUser() but that gives me issues someone tagged me in comment also.

Regards

Dipti

[Dipti Pandya]

creating a new query for above question