Exam ACP-120 Topic 1 Question 22 Discussion

To create a filter that shows issues created during the last calendar month, the JQL query must use the createdDatefield 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 like startOfMonth()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), and endOfMonth(-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-1 mrefer 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")
* createdDate >= startOfMonth(-1) OR createdDate <= endOfMonth(-1) (Option B):
* TheORoperator creates a logical error, selecting issues created after the start of the previous monthorbefore the end of the previous month, which includes almost all issues.
Additionally,-1is ambiguous and typically invalid without a unit (e.g.,-1mfor one month).
The correct operator isANDto define a range.
* Extract from Documentation:
UseANDto define a date range (e.g., createdDate >= startOfMonth(-1m) AND createdDate <= endOfMonth(-1 m)).ORcreates an overly broad range.
(Source: Atlassian Support Documentation, "Advanced searching - operators reference")
* created >= startOfMonth(-1) AND created <= endOfMonth(-1) (Option C):
* The-1syntax without a unit (e.g.,-1m) is ambiguous and typically invalid in JQL. The correct syntax uses-1mto indicate one month ago. Additionally, whilecreatedis an alias for createdDate, the incorrect time unit makes this query invalid.
* Extract from Documentation:
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