Filtering by date

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?

4 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

7 votes

Answer accepted

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"

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

2 votes

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"

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

2 votes

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Hi @Julian Haines

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

Regards

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Was this helpful?

Thanks!

Jira Service Management

DEPLOYMENT TYPE

CLOUD

PRODUCT PLAN

PREMIUM

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Filtering by date

4 answers

1 accepted

Comments for this post are closed

Comments for this post are closed

Was this helpful?

Thanks!

DEPLOYMENT TYPE

PRODUCT PLAN

TAGS

Atlassian Community Events