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

tubage 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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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