Hi @Yi Liang
I do not see how to do it with JIRA without app. It should work with Scriptrunner using
dateCompare(Subquery, date comparison expression)
https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Yi Liang , welcome to the community.
Unfortunately, JQL does not allow you to compare dates. One option you could consider would be to use automation a company with a custom field. The concept is to set the custom field if the resolved date is greater than the required date. Automation allows for this comparison. Then you can use the custom field in your JQL, for example…
date-exceeded = true
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Yi Liang
You could do this with Jira automation
In the automation rule use smart values to do a date compare, in combination with a issue lookup
https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-compare---
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please accept my answer as a solution.
This will help other community member trying to solve the same.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.