Comparing Planned End Date and End Date

[Reuben Bezzina]

I would like to know that JQUERY script that I should use to list all the tasks in a particular project that the Planned End Date is less then the End Date.  Trying to use the following but is not working and the SQL helper is not displaying any correct suggestions.

I am trying to do something like the below.

project in ("Overall System") AND "Planned End Date" < "End Date"

Thanks.

[Tansu Akdeniz · Accepted solution]

Hi @Reuben Bezzina ,

Welcome to community.

Do you have Script Runner add-on? If yes, you can use the following query.

issueFunction in dateCompare("", "Planned End Date < End Date")

Please check this link for more information.

Regards

[Reuben Bezzina]

Thanks @Tansu Akdeniz .  Let me check with our administrator

[Tansu Akdeniz]

You can see the function in issue navigator if you have it.

[Reuben Bezzina]

Thanks.  I think we need to buy the addon as it is not there. The link that you sent me is really helpful btw,

[Tansu Akdeniz]

You are welcome @Reuben Bezzina