Filtering by date

[Julian Haines]

Good day,

I am trying to write a JQL to filter any issues created on the 10th April 2025 but its not returning anything, the JQL I am using is 

created = '2025-04-10'

The created date is shown as '10 Apr 2025' in Jira but if I try and use this it says wrong format.

Is this why its not working?

[Jack Brickey · Accepted solution]

Hi @Julian Haines , since the created date includes a time component you must bound the date for the 24h period. 

createdDate >= "2025-04-01" and createdDate < "2025-04-02" 

[Marc - Devoteam]

Hi @Julian Haines 

Filtering on date it's required to use yyyy-mm-dd.

You can change the look and feel for dates in the system, but for JQL this does not apply.

JQL to use is: created >= "2025-04-10"

Or to be completely sure on issue on a sinlge day,

created >= "2025-04-10" AND created < "2025-04-10"

[Nico Maikranz]

I think when you use 'created = '2025-04-10'' jira is automatically adding a timestamp to the jql.

So in the background its "created = '2025-04-10 00:00:00'" and there are no tickets with that exact time.

You should getting results with the following jql:

created > '2025-04-10' and created < '2025-04-11'

if you want to get work items for that specific date

[Florian Bonniec]

Hi @Julian Haines 

Are you using '10 Apr 2025' or 2024-04-10 ? From the screenshot it seems to be '10 Apr 2025'

Regards