Custom card color based on duedate with "between date"

[Jonathan Van Belle]

Hello,

I would like to configure an agile board (kanban view) in jira with some specific card colors based on JQL. I'm nearly the good configuration, but I don't find how to configure one

• duedate is NULL OR duedate > "+3d" : green
• duedate between 3d in the future and now : yellow
• duedate = now() : orange
• duedate < now() : red

the yellow one, i don't know how to make the query. Any idea?

[MichałS · Accepted solution]

(duedate > now() AND duedate < "3d")

[Jonathan Van Belle]

I have tried but having some conflict, after another test with your solution I do the following change on the green one : 'duedate is NULL OR duedate > "3d"'
Now everything is ok.

[MichałS]

JQL does not accept the "+" sign only the "-" is accepted. Its kind of strange but thats how it works :).