Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Configuring Kanban Card Colors for Past Due Date


I am still new to writing syntax for JIRA. I would like to configure my Kanban board that when the Story card goes past due based on the due date, the card turns red. Not sure what I should use to do this and my attempts have failed. Can someone help? 


1 answer

1 accepted

2 votes
Answer accepted
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 29, 2019

Hi Jessica,

you can use one of the following JQLs. you may need to tweak a bit to match your statuses, etc. You Card Color by Queries and paste one in to get started. You can get fancy if you want and show red for past due, yellow for due w/in x-days, etc.

due <= now() AND status not in (done, closed, resolved)

due <= now() AND resolution is not EMPTY (note, if you are not religious about setting the Resolution when closing issues then this won't work)

This was great. Thank you!! 

Jack, thanks so much! I was able to adapt this to get my cards to change color if they are not updated on time! 

"Script Ready Date" <= now() AND status = "Staged"

So glad I found this post from 3 years ago, lol!

Megan Thompson
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!
May 10, 2023 • edited

An improved query would be due <= now() and statusCategory != Done. That will capture all your done categories so that you don't have to type them manually.

Like Jack Brickey likes this

Suggest an answer

Log in or Sign up to answer