# CHANGELOG: Sep 27 / Milestones on Timeline, Date Ranges in Formulas, Filter Linked Entities in Rules **URL:** \ **Category:** Changelog\ **Created:** [September 27, 2021, 10:32am UTC](https://community.fibery.io/t/changelog-sep-27-milestones-on-timeline-date-ranges-in-formulas-filter-linked-entities-in-rules/2061 "2021-09-27T10:32:53Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![antoniokov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/antoniokov/32/201_2.png) [@antoniokov](https://community.fibery.io/u/antoniokov)\ **Post date:** [September 27, 2021, 10:32am UTC](https://community.fibery.io/t/changelog-sep-27-milestones-on-timeline-date-ranges-in-formulas-filter-linked-entities-in-rules/2061/1 "2021-09-27T10:32:53Z")
## Milestones on a Timeline > [@\[✔️DONE\] Milestones on a Timeline](https://community.fibery.io/t/in-dev-milestones-on-a-timeline/671): > > We deal with alot of deadlines in our work, would be good to mark dates on timeline view so we can work backward Add crucial dates as milestones to any Timeline View: ![milestones-on-timeline-fictional](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/9b97edd5151126a8f69e2fbc95e2ea40acfdd4a6.png) Releases, conferences, product launches — everything preceded by 🔥🚒 time is a good candidate to visualize as a milestone. In a classic Fibery fashion, there are no hardcodes: pick any Type(s), any common Field, and use the usual filters to keep truly relevant events only. ## Date Ranges in Formulas and Automations > [@\[✔️DONE\] Date Ranges in Formulas](https://community.fibery.io/t/how-to-add-days-to-date-time-range-by-formula/1739): > > So I get how to add days to a date using a formula. For example a button that extends Due date by 30 days: [Step 1 Task].[Due Date] + Days(30) How do I accomplish the same when using Date Time Range for Start and End dates? Add 30 days to date time range: Jul 1, 2021 00:00 → Jul 2, 2021 00:00 Calculate date ranges (with or without time) in Formulas, Rules, and Buttons: ![date-ranges-in-formulas](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/98bf2799d612b006bbba89635b2c4e56e11b8598.png) Date ranges are surprisingly tricky to handle as you can see from the bugs like these: > [@Result from formula to get end date from date range is wrong](https://community.fibery.io/t/result-from-formula-to-get-end-date-from-date-range-is-wrong/1917): > > Seems like this might be related to this old bug reported by @Chr1sG not sure if it was ever fixed: [Converting an End date to text](https://community.fibery.io/t/converting-an-end-date-to-text/1302) So if I have a date range field called Invoice Period and then I create a formula field with the formula of [Invoice Period].End the result isn’t actually the end date but the end date + 1 day. So if Invoice Period is “Jan 1, 2022 → Jan 9, 2022” the [Invoice Period].End formula incorrectly produces a Jan 10, 2022 result. Here is a demonstration of the bug: … I mean, it’s ridiculous how much time we have spent arguing over the most consistent and predictable behavior 😑. Here are the TLDR updates: 1. New `DateRange(startDate, endDate)` and `DateTimeRange(startDateTime, endDateTime)` functions. 2. `[Date Range Field].End()` syntax instead of `[Date Range Field].End`. @Chr1sG has prepared a [guide for the power users](https://help.fibery.io/en/articles/5598869-date-ranges-in-formulas). ## Filter linked Entities in Automations When updating, deleting, or unliking linked Entities in Rules and Buttons, narrow the action down to relevant Entities: ![filter-linked-entities-automations](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/3d02692dace7e96e6f37c2a8e06b299a71451132.png) “All or nothing” is not our approach here anymore 😅 ## ✨ Small improvements - Notification on a broken Rule now contains a link to the Rule’s configuration page. - Activity log in Automations now includes links to affected Entities. - `/me` command is back to Slack. ## 🦐 Fixed bugs - 🎈 Timeline automatically horizontally scrolls to the left. - Timeline: moving start date one day moves the end date too. - Automations: a to-many relation Field is updated even if already has the correct value. - Automations: broken error messages in FF and Safari. - Whiteboard: text in edit mode is displayed diagonally. - Whiteboard: It’s impossible to draw a connection line from or to Sticky Note. - Live updates not working on externally shared Entities. - Documents: losing focus while mentioning a user using `@` symbol. - Documents: avatars are displayed incorrectly in linked text. - Back-references in Audit Log deleted by a mysterious Fibery user. ---
**Author:** ![v3j](https://avatars.discourse-cdn.com/v4/letter/v/f07891/32.png) [@v3j](https://community.fibery.io/u/v3j)\ **Post date:** [October 29, 2021, 5:02am UTC](https://community.fibery.io/t/changelog-sep-27-milestones-on-timeline-date-ranges-in-formulas-filter-linked-entities-in-rules/2061/2 "2021-10-29T05:02:43Z")
hi there, just to confirm, if there are 2 milestone entities falling on the same date, only one of them can be seen in the timeline right? Although upon further checking, the other one is there, but just behind the other entitiy. i wish i could see both entities when I hover over the milestone vertical line