Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Group by date rather than datetime

cancel
Showing results for 
Search instead for 
Did you mean: 
Jason_Carlin
5 - Automation Enthusiast
5 - Automation Enthusiast

I’d love the ability to view my records grouped by date rather than date+time.

It’s rare to have a large number of records with the same exact date+time, but common to have a large number of records with the same date and different timers — at least for me. Seeing those records grouped by date and sorted (within each group) by time would be extraordinarily useful.

5 Comments
Christoff
7 - App Architect
7 - App Architect

Let’s say you have a date field called “Date Due”, and this field has “Include a time field” checked.
Create a formula field that consists of {Date Due}. In Formatting, uncheck “Include a time field”.
Group by this new field and sort by Date Due.

Jason_Carlin
5 - Automation Enthusiast
5 - Automation Enthusiast

Yeah, I’ve done that. It’s not great. Plus, it prevents me from being able to add any new records in that view.

Christoff
7 - App Architect
7 - App Architect

How does adding a formula field prevent you from adding new records?

Jason_Carlin
5 - Automation Enthusiast
5 - Automation Enthusiast

You can’t add records to a base that is sorted by a formula column

Christoff
7 - App Architect
7 - App Architect

:slaps head:
Makes sense.