nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Compare 2 custom date fields in jira issue filter

ashleyg

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

Accepted answers

All comments

ashleyg

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

ashleyg

Hi,

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

Sir Be

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)

ashleyg

Hi,

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

Sir Be

Jira-version?

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?

ashleyg

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud