Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Search by created date

When doing a selection of issues by created date in Jira Service Desk section issues/search for issues, with the basic mode of research, we have noticed that the starting date we type in is included in the selection, but the final date is excluded. For exemple, if we type in issues created between June 1st and June 30th, issues created on June 1st will be in the results, but not issues created on June 30th. This leads to wrong results. 

Do you confirm this is a bug ?

Note, we use the version 3.15.3 of Service Desk.

Thank you

1 answer

0 votes
Ismael Jimoh Community Leader Jul 15, 2019

Hi @Aline_Charlon 

For more granular dates, I would recommend switching to advanced mode in your search.

In Basic mode, JIRA is searching for issues created between the first date and before the last date.

In advanced mode, you can use the following to achieve what you wanted:

(created < firstDate and created >= lastDate)

If you would Atlassian to change the official behaviour, I would suggest raising a ticket at .

Hope this helps.


Ok I have raised a ticket. The solution you propose doesn't work. 

Thank you for your answer.

Ismael Jimoh Community Leader Jul 18, 2019

Hi @Aline_Charlon ,

I tested this on my instance and it works just fine:

created > startOfYear() and created <= startOfMonth() ORDER BY created ASC

Can you share your exact filter so I can see if there was a mistake with this?

Also, try the filter in the JIRA search issue page to make sure it works and then only implement this in your JSD project.

  • If the search does not work in your search issue, it will not work here as well.

Will be happy to help.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Desk

The Complete Guide to Atlassian for ITSM

Hi Atlassian Community! This is Teresa from the Atlassian team. My colleague Paul Buffington @Buff and I are excited to share a brand new ITSM resource we’ve created – "The Complete Guide to At...

2,259 views 14 22
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you