JQL colouring

[Gary]

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]

Did you try this way?

[Anandhi Arumugam _Cprime_]

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]

Welcome @Gary 

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

[Fazila Ashraf]

Hi @Gary 

Welcome to community!

I suppose the problem here is the sequence

> now is also >-2d  :) 

Reorder them with the now() first and then -2d and let me know whether that helped