Group by date rather than datetime


#1

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.


#2

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.


#3

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


#4

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


#5

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


#6

:slaps head:
Makes sense.