Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

how to compare the currentdate with a a certain customfield date field in JQL

tubage
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 16, 2019

as shown in the pictutre ,

project = DEMO AND issueFunction in dateCompare(""," TODAY()>duedate")

 

we use duedate as a deadline,I want to show how many issues have exceeded the limited time ,so i want to use a date field compare with the duedate,but i can't find how to fine now ?  i try with  today().now().currenttime,currentdate, all failed , what is the corrent word about  today ? 

date.png

1 answer

1 vote
Leo
Community Champion
December 16, 2019

Hi @tubage,

If you want to find the issues who crossed it's duedate/deadline, you can go with normal built-in options

like below

project = KEY AND duedate <= startOfDay() AND resolution is EMPTY  //due date is less or today

duedate <= -1d // whose due date crossed already

Hope this gives your some idea

 

BR,

Leo 

Suggest an answer

Log in or Sign up to answer