I think I’d be fantastic if we could use the Date and Time property in a more natural and unified way, just like it works in, for example, Google Calendar.
For example:
I have a table of “Events”. These events might be all-day events, or might occur at certain time. They might even take a couple days.
It would be nice if for every “Date and time” column we could define:
[mandatory] Start date, [optional] start time
[optional] End date, [optional] end time
…instead of having to create two columns to accomplish this. Also, this would make it really easy to visualize data in a calendar or timeline view.