In JQL, created with = operator is not working

[Piyush Patel]

I created a few issues on 07/May/2021, and try to get by following JQL. But I didn't get those issues.

created = "07/May/2021"

[Dirk Ronsmans · Accepted solution]

Hi @Piyush Patel ,

Keep in mind that if you put a specific date it means 00:00 of the day as well.

You could try ">" and "<"

also be sure to keep the correct format for your system language.

For me for example  i need to put yyyy-MM-dd as my format. 

So you could do 

created >= "2021/03/07" AND created <= 2021/03/08

I believe this should give you all the issues created during the day of 7/Mar/2021

[Martin Bayer [MoroSystems, s.r.o.] · Accepted solution]

Hi @Piyush Patel the problem here is that created date stores Date and Time. So if you want to use "=", you need to put date and exact time to the condition. So the correct and easiest condition is created >= "2021/05/07" AND created < 2021/05/08

[Yuliia_Borivets__SaaSJet_]

Hi @Piyush Patel 

I believe the following request should work for you:

created >= "2021/05/07" AND created <= "2021/05/08"

The other option I can recommend is the Dynamic Filters: JQL Replacer add-on. It allows you to set queries without JQL knowledge. 

For your query, you can choose created within thee last 1 day as shown below:

Or set the dates you need from the drop-down calendar:

Hope you find this info helpful.

Best regards

[Jack Brickey]

Have you tried createddate?

[Piyush Patel]

Yes