JQL colouring

Question

Looking for some help on the correct JQL for colouring cards based on due dates within issues.

I have tried to write a JQL to colour a card amber if due date of task is within 3 days, I have additionally tried to write a JQL to colour a card red if the due date is today or over due.

This hasn't worked and a date which is now in the past is still showing as amber rather than red.

Can anyone tell me how I should write my JQL to remedy this.

Divya Shree_6o7ujf · Answer

Did you try this way?

Anandhi Arumugam _Cprime_ · Answer

Hi @Gary Welcome to the community!

duedate >= "0" AND due <=3d for the issues due in the next 3 days and not overdue

duedate <= "0" for issues now overdue

Hope that helps!

Nikola Perisic · Answer

Welcome @Gary

* For amber color date, try using: due = "3d"
* For red color date try using: due <= now()