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 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 …

Good news :star_struck: [image] CHANGELOG: Sep 27 / Milestones on Timeline, Date Ranges in Formulas, Filter Linked Entities in Rules Changelog Milestones on a Timeline https://community.fibery.io/t/in-dev-milestones-on-a-timeline/671 Add crucial dates as miles…

Maybe related: Formula adds one day to Max dates

It also looks like when creating an entity via the API with an start/end date type the end date incorrectly set to the day before. I can confirm this because I submitted the same exact date in the same request and the regular date is set correctly but the end date is incorrect. With this many probl…

I thought it would be sensible to write something to explain the underlying cause of this issue, so that those who are experiencing it can understand it and find ways to avoid the problems described here (and in the other related issues). This isn’t to say that the behaviour is to be expected, or t…

[image] Chr1sG: the value of DateRange.End as stored internally (= date shown in UI +1 day). I think the fix would be directed at undoing this. There would clearly be some data migration necessary or maybe adding custom handling to DateRange.End - DateRange.Start for legacy support. But havi…

Yep, there’s no easy fix, and any solution is likely to break backwards compatibility for some people in some places :frowning: I just figured it was fair to be open about things.

[image] Dimitri_S: There would clearly be some data migration necessary FYI: if you had used .End in a formula previously, we will swap it over to .End(false) so that everything should still work as you set it up.

Thanks! :raised_hands: To sum up from the changelog: [image] CHANGELOG: Sep 27 / Milestones on Timeline, Date Ranges in Formulas, Filter Linked Entities in Rules Here are the TLDR updates: New DateRange(startDate, endDate) and DateTimeRange(startDateTime, endDateTime) functions. [Date Range F…

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

Bugs & Issues

Chr1sG September 27, 2021, 10:40am 8

Good news

Topic		Replies	Views
DateRange end is off by one second when using Date picker UI Bugs & Issues	1	68	July 10, 2024
[✔️DONE] Date Ranges in Formulas Ideas & Features formulas	2	805	September 27, 2021
[FIXED] Converting an End date to text Bugs & Issues	1	663	January 15, 2021
Date-range field inconsistency between UI and API Bugs & Issues	1	78	August 29, 2025
CHANGELOG: Sep 27 / Milestones on Timeline, Date Ranges in Formulas, Filter Linked Entities in Rules Changelog	1	1297	October 29, 2021

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

Related topics