Need help on search option

[Kamal Dhingra]

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!!   

[Jack Brickey]

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 

[Kamal Dhingra]

Thank you Jack!!

Actually I was looking for something in JQL to fix this.

I am new to JIRA, let me try this.

[Jack Brickey]

You cannot achieve this with JQL.

[Jira Guru]

Try this

due < created

[Kamal Dhingra]

Thank you Guruvayrappan G R

It did not work as it threw an error