Title
Created Date Filter in Basic View Excludes End Date
Description
While using the Basic Filters view in Jira (non-JQL mode), we’ve observed that the end date selected in a date range is not included in the results.
Steps to Reproduce
Navigate to Filters / Issue Search
Use the Basic view (not JQL)
Apply a filter on the Created field
Select a date range (e.g. 1 March to 31 March)
Run the search
Actual Result
Issues created on the end date (31st March) are not returned. The results only include issues up to 30th March.
Expected Result
The filter should return all issues created within the selected date range, including the end date.
Impact
Incomplete data for reporting and dashboards
Potential inaccuracies in month-end reporting
Additional manual validation or workarounds required
Additional Observation / Query
Could you please confirm if this is expected behaviour or if there is a recommended approach to ensure inclusive date filtering when using the Basic Filters view?
Hello @Hemant Tiwaskar
Welcome to the Atlassian community.
Created is a timestamp including both date and time. If you elect to filter based only on date then the effect is to create a filter that uses the specified dates and the time of 00:00.
If you create such a filter in Basic view and change to JQL you will see that is displays like this:
created >= "2026-04-24" AND created <= "2026-04-27" ORDER BY created DESC
That is effectively looking for issues create on or after 2026-04-24 at 00:00 and before or on 2026-04-27 at 00:00. Items created later in the day on 4-27 will be excluded by the time component of the timestamp.
To filter in an inclusive way you will have to specify the end date as your target day plus 1 day.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.