Tasks delivered late

[Marcus Pires]

Lets say that I need to know everything that has been delivered late in the past.

how would my query be?

[John Funk]

Hi Marcus - Welcome to the Atlassian Community!

There is no out of the box function with JQL to compare dates like that. You can use something like ScriptRunner to do that. 

Or you can create a custom number field and populate with the difference of the two date fields when the issue is delivered (using something like Automation For Jira or ScriptRunner or JMWE for workflows). Then you create a report where the custom field is > 0 (or < 0 depending on how you are writing your script). 

[Marcus Pires]

I understand John, but which fields should I compare?

targerEnd and ???

[John Funk]

Due Date and Resolved (or if you use a different custom field for the delivery date). 

[Marcus Pires]

i tried 

project = PP  AND DueDate < Resolved

but doesn't work

[John Funk]

No - see my note above - you cannot directly compare two dates in JQL out of the box.