I've got two JQL queries:
createdDate > startOfMonth() and createdDate < endOfMonth()
createdDate between startOfMonth() and endOfMonth()
Can someone explain to me why the former JQL query will run while the latter will not?
The way Jira implements the between is through the use of the dual notation, showing both the start and end threshold as you did on 1.
For example, if you apply this on Basic Search:
It gets translated into:
created >= 2022-05-01 AND created <= 2022-05-02
Even though "between" is considered a keyword (this list is hardcoded) I could not find any implementation of it which means it won't work for date values either.
We have to stick to the implementation provided above - using a lower and an upper threshold separately.
I'll look a bit more if there's any application for "between" and will reply back if I find anything.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event