# January 9, 2025 / 🥳 Set any relative value in Date Filter, Batch change fields for selected entities, Improved readability in rich text fields, some new formulas **URL:** \ **Category:** Changelog\ **Created:** [January 9, 2025, 3:09pm UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082 "2025-01-09T15:09:32Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [January 9, 2025, 3:09pm UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/1 "2025-01-09T15:09:32Z")
First release in 2025 brings you some good stuff! ## 🥳 Set any relative value in Date Filter We’ve significantly expanded our Date Filter capabilities to support more flexible time-based filtering. When filtering by Date Field, you can now choose from convenient preset options like “today,” “yesterday,” and “one week from now,” or use the “custom date” option to select either specific dates or relative timeframes. The “is within” operator has also received a major upgrade. You now have the freedom to combine absolute and relative dates at both ends of your date range, moving beyond simple preset ranges like “past week.” Here are some examples of what you can do: - Set a range from a specific date to another specific date (e.g., from January 1st → to January 15th) - Mix a specific date with a relative one (e.g., from January 1st → to 5 days ago) - Use relative dates on both ends (e.g., from 10 days ago → to 2 weeks from now) 💡 Pro tip: Need to filter for today’s data? Simply use “0 days ago” or “0 days from now” as your relative value. ## 🏋️‍♀️ Batch change fields for selected entities (experimental) Now you can select many entities and change fields for the selected entities fast. For example, you can change state for selected tasks, assign people, change dates, etc. NOTE: Enable it in Settings → Experimental Lab. ## 🤓 Improved readability in rich text fields We made enhancements aimed at improving readability across our text editor. Key updates include: - Tweaked Checkbox item UI. - Enhanced Title, Headings, Lists, Callout and Quote styles. - Optimized spacing between all types of content inside rich text fields. ## 📆 New formulas: Add month to a date and get week number We’ve add two new formulas and some operations with dates became simpler: ### Months(number): Add month to a date Returns a Duration for the number of months. For example, you want to create a field that will show the date 1 month before the deadline. ```auto [Due Date] - Months(1) ``` Or you can add half a year to a date: ```auto [Date] + Months(6) ``` ### IsoWeekNum(date): Calculate the week number in Formulas Returns number of the ISO week number of the year for a given date. ```auto IsoWeekNum([Creation Date]) → 23 ``` ## 🦋 Improvements - You can now downgrade from a paid plan to Free with a couple of clicks and without contacting us (although we’d appreciate frank feedback before you go). - Fibery-to-Fibery sync feature demands Enterprise plan now. - Monthly usage limits for automations and integrations infographic is unambiguous now about whether it’s 10% left or 10% used. - More operators were added to text filter in views: is, is not, starts with, ends with. ## 🦐 Fixed Bugs - Filters: doesn’t contain doesn’t work with empty fields - “Sync failed” label should not be cut - Error appears when Admin creates Highlight database - Can’t rename database - If Solo workspaces reaches monthly usage limits, upgrade to Standard is meaningless - Issue with ‘Locked’ icon for embed and relation views - ‘Duplicate’ option should not be disabled for locked document/view - Function is not get selected in list below for multiline formula - Selecting the same DB when setting up a form resets everything - White background instead of pricing page on opening Chargebee pop-up in the dark theme ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [January 9, 2025, 3:09pm UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/2 "2025-01-09T15:09:42Z")
---
**Author:** ![lars](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/lars/32/7322_2.png) [@lars](https://community.fibery.io/u/lars)\ **Post date:** [January 9, 2025, 3:28pm UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/3 "2025-01-09T15:28:29Z")
Super awesome update! Fixes a lot of my pet peeves, and I’m super excited for relative time filters. Thank you – just one little addition… > [@mdubakov](#): > > IsoWeekNum(date): Calculate the week number in Formulas I’m hoping for `IsoWeekYear(date)` next to replace my [cumbersome existing](https://community.fibery.io/t/week-number-formulas/3880) week calculation formulas 🙂 ---
**Author:** ![Mircea\_Braescu](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mircea_braescu/32/9729_2.png) [@Mircea\_Braescu](https://community.fibery.io/u/Mircea_Braescu)\ **Post date:** [January 9, 2025, 3:37pm UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/4 "2025-01-09T15:37:03Z")
> [@mdubakov](#): > > Batch change fields for selected entities (experimental) This looks like an excellent addition, but you should make it clear it doesn’t work for tables yet (it does for lists + boards) ---
**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 9, 2025, 3:48pm UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/5 "2025-01-09T15:48:11Z")
> [@lars](#): > > I’m hoping for `IsoWeekYear(date)` next to replace my [cumbersome existing](https://community.fibery.io/t/week-number-formulas/3880) week calculation formulas 🙂 Did you see the [improved version](https://community.fibery.io/t/week-number-formulas/3880/6) that became possible due to the Weekday function that was recently introduced? ---
**Author:** ![Jonathan1](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/jonathan1/32/10038_2.png) [@Jonathan1](https://community.fibery.io/u/Jonathan1)\ **Post date:** [January 9, 2025, 4:10pm UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/6 "2025-01-09T16:10:12Z")
> [@mdubakov](#): > > Months(number): Add month to a date Thanks for that ! ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [January 9, 2025, 4:12pm UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/7 "2025-01-09T16:12:32Z")
> [@mdubakov](#): > > Set any relative value in Date Filter > [@mdubakov](#): > > IsoWeekNum(date): Calculate the week number in Formulas These 2 are the best updates this week for us, thank you! ---
**Author:** ![chris.burchartz](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chris.burchartz/32/662_2.png) [@chris.burchartz](https://community.fibery.io/u/chris.burchartz)\ **Post date:** [January 10, 2025, 5:26am UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/8 "2025-01-10T05:26:05Z")
Hey guys, relative dates looks great (UX is also very smooth) - but I have one scenario, which doesn’t work out: Very often I want to see entities from the last month, next month etc. With relative filters, I will only get +/- one month relative to todays date - but I need the whole month. E.g. "show me all invoices from last month (Dec 1 2024 till Dec 31 2024). Have I missed something or is this just not possible? And thumbs up for “Batch edit” - big step forward! ---
**Author:** ![njyo](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/njyo/32/923_2.png) [@njyo](https://community.fibery.io/u/njyo)\ **Post date:** [January 10, 2025, 8:39am UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/9 "2025-01-10T08:39:02Z")
Great start to the new year! Love these small but meaningful fixes: Relative filters and Month/Week formulae. 🙂 Also rich text refinements are always welcome. 🙂 ---
**Author:** ![lars](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/lars/32/7322_2.png) [@lars](https://community.fibery.io/u/lars)\ **Post date:** [January 10, 2025, 8:43am UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/10 "2025-01-10T08:43:20Z")
> [@Chr1sG](#): > > Did you see the [improved version](https://community.fibery.io/t/week-number-formulas/3880/6) that became possible due to the Weekday function that was recently introduced? Only now. Thanks for the hint, that looks easy enough for a formula 🙂 ---
**Author:** ![Michael\_Ichter](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/michael_ichter/32/9931_2.png) [@Michael\_Ichter](https://community.fibery.io/u/Michael_Ichter)\ **Post date:** [January 10, 2025, 10:57am UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/11 "2025-01-10T10:57:59Z")
> [@Mircea\_Braescu](#): > > > [@mdubakov](#): > > > > Batch change fields for selected entities (experimental) > > This looks like an excellent addition, but you should make it clear it doesn’t work for tables yet (it does for lists + boards) I second this. We use table view a lot instead of list view because the table view highlights field data more prominently. I love the relative date, batch edit, and rich text readability updates! Thanks for the hard work! ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [January 10, 2025, 11:32am UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/12 "2025-01-10T11:32:35Z")
> [@Michael\_Ichter](#): > > I second this. We use table view a lot instead of list view because the table view highlights field data more prominently. We will add batch edit panel to table view soon, I hope in the next release ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [January 10, 2025, 4:03pm UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/13 "2025-01-10T16:03:25Z")
Oh yeah, after checking out the updates a bit more, I agree. Could we get the following relative scenarios added? (assuming “First day of the week” preferences are set to Sunday) - **[This Week]** - **[Last Week]** - **[Next Week]** - **[This Month]** - **[Last Month]** - **[Next Month]** - **[This Year]** - **[Last Year]** - **[Next Year]** ---
**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\ **Post date:** [January 10, 2025, 8:23pm UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/14 "2025-01-10T20:23:13Z")
> [@interr0bangr](#): > > Could we get the following relative scenarios added? > > (assuming “First day of the week” preferences are set to Sunday) Yes I really miss those scenarios as well! Plus ‘this/last/next quarter’ since we do a lot of quarterly planning as well. We’ve build a very complex planning solution to achieve this; would be awesome if we could skip that solution and only use filters instead 😍😍 ---
**Author:** ![Illusory](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/illusory/32/10403_2.png) [@Illusory](https://community.fibery.io/u/Illusory)\ **Post date:** [January 11, 2025, 4:19pm UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/15 "2025-01-11T16:19:46Z")
> [@Michael\_Ichter](#): > > We use table view a lot instead of list view because the table view highlights field data more prominently. Thirding this. We would love to see batch edits for all views (Table especially). ---
**Author:** ![ebell](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ebell/32/1293_2.png) [@ebell](https://community.fibery.io/u/ebell)\ **Post date:** [January 12, 2025, 9:28pm UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/16 "2025-01-12T21:28:32Z")
> [@mdubakov](#): > > We made enhancements aimed at improving readability across our text editor. Suttle change, but looks better. What would be really helpful is to reduce the space between bullet points and new lines. I came over from Logseq and often write with bullet points. Out of any writing tool, Fibery adds way too much space between the bullet point lines…which makes it bullet point list less aesthetically pleasing and useful. ---
**Author:** ![aarkhipau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aarkhipau/32/10866_2.png) [@aarkhipau](https://community.fibery.io/u/aarkhipau)\ **Post date:** [January 15, 2025, 11:06am UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/17 "2025-01-15T11:06:07Z")
I’m glad you noticed and liked the change 😊 I understand the concern, especially if you’re used to tighter list spacing in other tools. In Fibery our rich text editor supports elements like mentions, tags, statuses, and avatars in all text lines, including bullet points. Reducing the spacing can make these feel cramped and harder to read. I’ll revisit this after we refine the design of these units, but for now, the current spacing ensures better readability. Thank you for this feedback! ---
**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\ **Post date:** [January 21, 2025, 1:07am UTC](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082/18 "2025-01-21T01:07:19Z")
I think these suggestions hit on a gap between where our need is and the feature update as-is. The new custom date option feels _over engineered_. I think it’s capable of helping me filter to this year but I have no idea which of the many options will do that. The functionality exists but the number of clicks and the way of figuring it out is prohibitive. It’s faster and easier to create a formula on the record Year(Today()) = Year(Date) and filter. The UX here is, well, rough.