Query syntax help: How to determine a critical issue by comparing 2 timestamps?

[Mohit]

Hey,

I am new to the query syntax. 

There are 2 timestamps: 

a) Delivery deadline & b) Print completion time (Captured from post function)

I want to create a filter that shows all jobs where difference between these 2 timestamps is less than 2 hours.

Kindly share what query I should use.

Thanks! 

[Tarun Sapra]

Hello Vernon,

Comparing dates isn't supported yet by the JQL in JIRA. 

Please see the following links 

https://jira.atlassian.com/browse/JRASERVER-20727

https://community.atlassian.com/t5/Questions/Is-it-possible-to-compare-date-fields-using-JQL/qaq-p/37331

https://community.atlassian.com/t5/JIRA-questions/JQL-Compare-Dates-Created-vs-Updated/qaq-p/339675

[Tarun Sapra]

Date compare is supported by means of plugins like Script Runner's JQL functions in JIRA

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_datecompare