# Result from formula to get end date from date range is wrong

**URL:** <https://community.fibery.io/t/result-from-formula-to-get-end-date-from-date-range-is-wrong/1917>\
**Category:** Bugs & Issues\
**Created:** [August 13, 2021, 9:11pm UTC](https://community.fibery.io/t/result-from-formula-to-get-end-date-from-date-range-is-wrong/1917 "2021-08-13T21:11:44Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![Dimitri\_S](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/dimitri_s/32/1683_2.png) [@Dimitri\_S](https://community.fibery.io/u/Dimitri_S)\
**Post date:** [September 27, 2021, 4:23pm UTC](https://community.fibery.io/t/result-from-formula-to-get-end-date-from-date-range-is-wrong/1917/10 "2021-09-27T16:23:35Z")

</div>

Thanks! 🙌

To sum up from the changelog:

> [@CHANGELOG: Sep 27 / Milestones on Timeline, Date Ranges in Formulas, Filter Linked Entities in Rules](https://community.fibery.io/t/changelog-sep-27-milestones-on-timeline-date-ranges-in-formulas-filter-linked-entities-in-rules/2061/1):
>
> 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).

---

_[View the full topic](https://community.fibery.io/t/result-from-formula-to-get-end-date-from-date-range-is-wrong/1917)._