# Filtering on Dates to add color **URL:** \ **Category:** Get Help\ **Created:** [July 24, 2024, 7:55pm UTC](https://community.fibery.io/t/filtering-on-dates-to-add-color/6432 "2024-07-24T19:55:04Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Jonathan](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@Jonathan](https://community.fibery.io/u/Jonathan)\ **Post date:** [July 24, 2024, 7:55pm UTC](https://community.fibery.io/t/filtering-on-dates-to-add-color/6432/1 "2024-07-24T19:55:04Z")
I use a Board view to list out my tasks by priority and day of the week. I have a “due date” field and I’m trying to configure some filter scheme that will add color when a task is due within the week. There’s a built-in filter for date fields. Exact date, today, tomorrow, and yesterday all make sense as options. However, one week ago / one week from now / one month ago / one month from now seem odd. It’s unlikely someone only wants the filter to apply if a date is _exactly_ on the one week or one month anniversary or exactly that long in the future. Ideally, it would be “within one week from now” instead of “one week from now”. So the color code could progress as the date draws closer or gets farther into the past. Is there some automation or something I could use to highlight upcoming due dates? I thought of calendar view, but that requires date ranges, where due date are single days, so that doesn’t seem quite right. Thanks for any tips / feedback. ---
**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:** [July 24, 2024, 8:03pm UTC](https://community.fibery.io/t/filtering-on-dates-to-add-color/6432/2 "2024-07-24T20:03:51Z")
You can add a color (or filter) based on that a date ‘is within the next week’ Isn’t this what you need? ![1000022882](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/33883f2f4f64364f58a029368ba1735620768eb4.png) ---
**Author:** ![Jonathan](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@Jonathan](https://community.fibery.io/u/Jonathan)\ **Post date:** [July 24, 2024, 8:08pm UTC](https://community.fibery.io/t/filtering-on-dates-to-add-color/6432/3 "2024-07-24T20:08:40Z")
Oof. Yea I totally missed that; I’m clearly rusty after returning to Fibery from some time away. Thanks so much for your time. ---
**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:** [January 30, 2025, 9:31pm UTC](https://community.fibery.io/t/filtering-on-dates-to-add-color/6432/4 "2025-01-30T21:31:57Z")
Closed on January 30, 2025, 9:31pm UTC