Date grouping error in daily note query
in progress
D
Dennis Villasana
I have a query in my daily note called "Due Today," which returns all of my Projects (a custom object I created, not the default object) where the Due date property "starts on or before today." I also have it set to group the results by the Due date property and "by day."
The query returns the correct results, but the date they are grouped by is always one day before the correct Due date. So, Projects that are Due September 29 are grouped under September 28, projects Due today are grouped under "yesterday," etc.
I'm on a Mac Studio, MacOS 26.0.1, and Capacities 1.53.17. Thanks!
Log In
Steffen Bleher
in progress
Thanks for sharing! Will be fixed with the next update :)
Steffen Bleher
Thanks for sharing and sorry for having issues. Could you share some your time zone and if the date objects are dates, dates + times or ranges?
D
Dennis Villasana
Steffen Bleher Hi Steffen - I'm in NYC (EDT). The date objects are dates only, no times or ranges. I just tried setting the Time and Range settings to "Disallowed," but it didn't make a difference. Let me know if I can provide any further info.
D
Derek Thurber
Steffen Bleher for me where this is happening, I am on Mountain Standard Time in the U.S. and the date property is a combination of both date and date + time + range values.
Beth
Merged in a post:
Query using group by a date property using "relative" is not sorting correctly
D
Derek Thurber
I have a query of upcoming action items where I am using the new group by a date property set to "relative" (which is amazing by the way!) and I noticed today that the group for "tomorrow" is showing up after the group for "this week" even though the items under this week are after tomorrow.
Using Capacities v1.53.17; none none; Mac OS v10.15.7; Chrome v134.0.6998.88 (WebKit v537.36); Desktop (Electron); 9/30/2025, 8:58:02 AM; en (America/Phoenix, UTC-7)
Beth
under review