# Colors in Cards based on End Date

**URL:** <https://community.fibery.io/t/colors-in-cards-based-on-end-date/5842>\
**Category:** Get Help\
**Created:** [February 13, 2024, 6:54am UTC](https://community.fibery.io/t/colors-in-cards-based-on-end-date/5842 "2024-02-13T06:54:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ivan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ivan/32/7294_2.png) [@Ivan](https://community.fibery.io/u/Ivan)\
**Post date:** [February 13, 2024, 6:54am UTC](https://community.fibery.io/t/colors-in-cards-based-on-end-date/5842/1 "2024-02-13T06:54:04Z")

</div>

I’m trying to do something very basic, but I’m unable to make it work correctly.

- If the end date of the Task is Today, I want to color it orange
- If the end date is in the past, I want to color it red
- If in the next week, green  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/99f8c4069764b13ff0e90a216ae04e8b5b367b9b.png)

But it isn’t working. At the moment of testing it:

- Day: Feb 13
- Local Time: 7:45
- UTC Time: 6:45

As you can see, if the end date is Feb 13 (Today) the card is green:  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/986f772f53c5783915c83d06297079d006285749.png)

If I put the date as yesterday, the card is Orange instead of Red (End Date in the past):  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/e/ecf71f686ef22864f391021c133a1242ee6b5809.png)

Only If I go back two days, I get the red card:  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/232b291bb84884c4259532d236a0e8d1465ea660.png)

According to the [Timezones documentation](https://the.fibery.io/@public/User_Guide/Guide/Timezones-41) the server uses UTC and I’m UTC+1 so this shouldn’t be a Timezone issue.

Any idea what I’m doing wrong?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [February 13, 2024, 8:02am UTC](https://community.fibery.io/t/colors-in-cards-based-on-end-date/5842/2 "2024-02-13T08:02:05Z")

</div>

It’s basically the same bug as this

[https://the.fibery.io/@public/User\_Guide/Guide/Date-Ranges-in-Formulas-42](https://the.fibery.io/@public/User_Guide/Guide/Date-Ranges-in-Formulas-42)

TLDR end dates don’t behave as expected in filters/sorting/color coding.  
Temporary fix is to use an offset of one day