Compare 2 custom date fields in jira issue filter

I have two custom date fields of Date Picker type namely Planned Delivery Date" and "Original Planned Date". I need to compare them using say > or < or != in a jira filter query but unable to achieve. Using scripted query:- issuefunction in datecompare ("","Planned Delivery Date> Original Planned Date") gives error response. please correct me on how to achieve this

3 answers

Can somebody please help me on the above issue. I need the solution urgently


Can somebody please help me to get some solution for my above mentioned query on how to compare two custom date fields in jira

Version of jira?

How about "Planned Delivery Date" > "Original Planned Date" ?

Cause datecompare doens't exist (I think).

Is the auto-complete on? Then it would suggest you what and how you can do this? (gives names and possible functions)


Many thansk for responding me.

Actually i tried out this initially but got typical jql error that these are not date fields and no further suggestions despite auto-complete on. Then since i have script runner plugin installed i tried out the query issuefunction in date compare (......) but it only gave me options to compare default jira date fields like resolutiondate and duedate,etc


Strange ...

Try to do it with their ID's?

I'm doing something quite similar (in jira 4.2, both are date custom fields)

("Start date" &lt;= now() and "End date" &gt;="-1d" )

So all issues appear that are with their dates fixed to today.

Does this help?

Are they date or date/time CF's?


Once again thanks for quick response.

Actually as i mentioned i have to compare two custom date fieldss which i'm not allowed to do despite using script runner plugin. Script runner only helps to compare two date fields against each other like resolutiondate>duedate using issuefunction in date compare query as i mentioned. In default jira you cannot even compare two defauilt jira date fields because utmost you can compare a dcefault jira date field with functions like currentlogin(),now(),etc. So please let me know how i can compare two custoim date fields in jql.

My jira version is 6.1.3

I'm sorry to say, but I don't know how I can help you further. :s

Search the Internet for help?

Add tags scritp-runner and issue-filter to you question, to get more help?

Good luck with it.

(When I saw your own response was each time a few minutes ago, I come check the page often)

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,647 views 18 21
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you