To create a filter that shows issues created during the last calendar month, the JQL query must use thecreatedDatefield with thestartOfMonth(-1m)andendOfMonth(-1m)functions to define the time range. The correct query iscreatedDate >= startOfMonth(-1m) AND createdDate <= endOfMonth(-1m)(Option D).
Explanation of the Correct Answer (Option D):
ThecreatedDatefield represents the date an issue was created. ThestartOfMonth(-1m)function returns the first day of the previous month (e.g., April 1, 2025, for May 2025), andendOfMonth(-1m)returns the last day of the previous month (e.g., April 30, 2025). The querycreatedDate >= startOfMonth(-1m) AND createdDate <= endOfMonth(-1m)selects issues created within this range, covering the entire last calendar month.
Exact Extract from Documentation:
Search for issues using JQL
ThecreatedDatefield (orcreatedalias) stores the creation date of an issue. Use date functions likestartOfMonth()andendOfMonth()to define time ranges.
Examples:
createdDate >= startOfMonth(-1m) AND createdDate <= endOfMonth(-1m) returns issues created in the previous calendar month.
Use-1mto indicate one month ago.Note: Ensure date fields use>=and<=for inclusive ranges.(Source: Atlassian Support Documentation, "Search for issues using JQL")
Why This Fits: The query in Option D correctly usescreatedDate,startOfMonth(-1m), andendOfMonth(-1m)withANDto define the last calendar month, making it the correct answer.
Why Other Options Are Incorrect:
created changed during (startOfMonth(), endOfMonth()) (Option A):
Thechanged duringoperator is used for fields that track changes (e.g., status, assignee), not for static fields likecreated. Additionally,startOfMonth()andendOfMonth()without-1mrefer to the current month, not the last month.
Extract from Documentation:
Thechanged duringoperator is invalid for thecreatedfield. Use>=and<=for date comparisons.
(Source: Atlassian Support Documentation, "Advanced searching - operators reference")
UseANDto define a date range (e.g., createdDate >= startOfMonth(-1m) AND createdDate <= endOfMonth(-1m)).ORcreates an overly broad range.
(Source: Atlassian Support Documentation, "Advanced searching - operators reference")
Date functions require units likemfor months (e.g.,startOfMonth(-1m)). Without a unit, the query is invalid.
(Source: Atlassian Support Documentation, "Advanced searching - functions reference")
Additional Notes:
The filter can be created inIssues > Search for issues, saved as a filter, and shared if needed.
Thecreatedalias can be used instead ofcreatedDate, butcreatedDateis more explicit and matches the options.
Ensure the Jira instance’s timezone aligns with the expected month range.
[:, Atlassian Support Documentation:Search for issues using JQL, Atlassian Support Documentation:Advanced searching - operators reference, Atlassian Support Documentation:Advanced searching - functions reference, , ]
Submit