Hi,
How to search for the tickets which have a due date prior to their creation date. (incorrect due date set by mistake )
Thank you!!
Try this
due < created
you will need an addon e.g. Scriptrunner or similar. With SR you can use the following I think...
issueFunction in dateCompare("", "duedate" < "created")
Actually you could also use Automation for this. Here is an article that might help - calculating-the-difference-between-two-dates
Thank you Jack!!
Actually I was looking for something in JQL to fix this.
I am new to JIRA, let me try this.
Thank you Guruvayrappan G R
It did not work as it threw an error
You cannot achieve this with JQL.
It looks like you're new here. Sign in or register to get started.