nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Jack Brickey

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"

All comments

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

Jack Brickey

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"

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

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"

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management