Configuring the color of the cards based on their creation date

[Marko F]

Hi all! I am trying to create JQL rules to change the colors of my still open cards based on the date of their creation. So if a card is one week or less old it should have a green border, between one and two weeks it should have a yellow border, and more than two weeks it should have a red border.

I wrote the following based on some web searches, but with them all my cards are green no matter how much time passes. What am I doing wrong?

[Duc Thang TRAN · Accepted solution]

Hello @Marko F 

I think it's the opposite for your queries 

For Red card  : created < -14d and Status != Done

For Yellow :  created >= -14d and created < -7d and status != Done

For Green : created > -7d and status != Done 

[Marko F]

Hello! I've just tried your solution and it works! Thank you very much :-)