I use two formulas that return Min and Max date of children to create a “total span”. The Max date gets an entire day added to it. I have not done further testing on when this happens. Replication: [image] Feature: ETA: Date with Start and End. Milestone: Start Date: Formula with Features.Mi…

Formula adds one day to Max dates

Chr1sG February 4, 2021, 5:55pm 2

Related to this I suspect.
It would be nice to know how dates (without times) are managed under-the-hood, because I’ve experienced a few similar issues.

Topic		Replies	Views
CHANGELOG: Sep 27 / Milestones on Timeline, Date Ranges in Formulas, Filter Linked Entities in Rules Changelog	1	1129	October 29, 2021
[✔️DONE] Date Ranges in Formulas Ideas & Features formulas	2	654	September 27, 2021
Result from formula to get end date from date range is wrong Bugs & Issues	8	1227	September 27, 2021
Timeline: Using a number field for the end condition Ideas & Features	3	67	March 23, 2024
Looking for a formula to match deadline to duration field in a different database Get Help	2	170	April 10, 2023

Formula adds one day to Max dates

Related Topics