am trying to find difference between two dates, the MINUS sign does not work, the datediff function does not work
Hi @Anne Varghese
Where are you trying to find the difference between these two dates?
Some more information about the feature or scenario would be great
Ste
That was a quick response, thank you;
sample Jira JQL on Jira board , below works, however, when I want difference between TWO DATES <typical scenarios is =ticket "technical approval date" should be less than 180days of "release date"> -
I tried datediff function, minus sign symbol - both failed.
sample query
project = S4 AND type = Epic and status in ("In QA", "Ready To Deploy To Production") ORDER BY status DESC
expectation:
project = S4 AND type = Epic and status in ("In QA", "Ready To Deploy To Production") AND
"TDA Approval Date" - "Target End Date" < 180d OR
datediff ("TDA Approval Date", "Target End Date" , "d") < 180d
How do I find difference between two dates using JQL, Atlassian Jira and Jira PluginsLicense Information for JiraJira v8.22.6
THANK YOU
This isn't possible natively - but do you have Automation on your Jira instance?
If yes, I would...
...and use this in the JQL search instead
Let us know if you'd like more specific instructions on how to do this!
There is nothing in out-of-the-box JQL to compare date fields. JQL is not an SQL, and so does not have such features.
How often do you need to perform this query?
And just to confirm, are you using Jira Cloud, as your post seems to indicate that? If so, Automation for Jira rules are built-in with that product. And it appears you are using the Premium license level, and so the impact of the execution limits are less likely to impact you if you need to create a rule.
Kind regards,Bill
It looks like you're new here. Sign in or register to get started.
