How do I group a date/time view by day?

By owntheweb on 9 Jun 2009 at 21:00 UTC

Hi,
I created a view to show "agenda event" nodes, and wish to group the agenda events by day. When editing the node, the user fills out a date/time field where a date is picked in a calendar, and a time is specified next to it. When creating the view, I can choose to group by date/time, but not just the date by itself. I'm so close, but here are some walls I'm hitting:

When defining the content type date/time field, I can't select time separate from the date. It's either date or date+time.
I can create a "day_only" date format in the date module settings. I can also add a formatted date field in views. But when I specify the field "Format" in views, my custom format will not show up on the list. It's only "default","as time ago", "long","medium","short".
If I group by my date/time field, every entry is a group even if there is a minute time difference (makes sense).
Finally: I can redefine the "short" format to YYYYMMDD, and group by that format. It works the way I want, BUT it shows YYYYMMDD format in the group labels. Sheesh! Is there a way I can override this?

Should I find a different module to use for time? I don't really want to let this one go. Maybe I specify a date field using this module, then a time field using a different module? Data-wise this doesn't sound all that great.

What are your thoughts? I appreciate the feedback.

Comments

Ok, still not working, but

owntheweb commented 9 June 2009 at 21:50

Ok, still not working, but here is some hope (just need some advise):

Using the last bullet option from above, I can check "Rewrite the output of this field". Cool. There's even options that show below to use as tokens:

Fields
* [field_agenda_event_date_value] == Content: Agenda Event Date (field_agenda_event_date)
* [title] == Node: Title
* [body] == Node: Body
* [field_agenda_event_date_value_1] == Content: Agenda Event Date (field_agenda_event_date)

OK. I could in theory use "[field_agenda_event_date_value]" and that would give me exactly what I want. When I use it though, the result is blank nothing. I could enter "HELLO" there and I would see "HELLO". If I enter "[title]" or "[body]" I see blankness as well. If I specify "[[title]]", I get "[]". :P

I'm almost there! Any thoughts on what I am missing?

Worlds to explore. Worlds to create.
Blog: http://www.christopherstevens.cc/blog
Twitter: http://www.twitter.com/owntheweb

Hmmm. I see it. If I uncheck

owntheweb commented 9 June 2009 at 21:54

Hmmm. I see it. If I uncheck "Exclude from display", I see the rewritten field being listed and rewritten, just not in the groupings. :(

I'll keep searching...

Worlds to explore. Worlds to create.
Blog: http://www.christopherstevens.cc/blog
Twitter: http://www.twitter.com/owntheweb

Got it! I redefined "Medium"

owntheweb commented 9 June 2009 at 22:06

Got it!

I redefined "Medium" to something like "Wednesday, June 10th, 2009", and added it as a hidden field, and grouped by it. It still orders the groups correctly e.g. Wednesday before Friday.
Then I redefined the "Short" field to show just the time like "4:08 PM", and showed that field
Now you see day groups, with time listings for that day underneath.

Sweet! Time to go celebrate.

Worlds to explore. Worlds to create.
Blog: http://www.christopherstevens.cc/blog
Twitter: http://www.twitter.com/owntheweb

dude u saved my life...

2by commented 21 June 2009 at 17:21

thx a lot

tubai (arpan chatterjee)

awesome!

owntheweb commented 22 June 2009 at 14:06

I'm glad my pain saved you some pain!

You can see the final results of this topic at: http://www.globalspacesummit.org/agenda

Worlds to explore. Worlds to create.
Blog: http://www.christopherstevens.cc/blog
Twitter: http://www.twitter.com/owntheweb

Any other solution?

caschbre commented 25 June 2009 at 02:13

I'm having the exact same issue. I used the date wizard to create an event content type with a from and to date/time. I also want to present an event list and group by the day. I don't want to redefine medium and short date formats because I'll use those formats elsewhere on the site.

Are there any other solutions out there?

-
_{@foggyperspectiv | foggyperspective.com (blog)}

Found the solution!

caschbre commented 25 June 2009 at 02:35

Ok... you don't need to modify the existing medium or short date formats... you just create new custom date formats. I created a Long Day and a time format. I found the answer reading Can nodes be grouped by Day in an Upcomming View?

-
_{@foggyperspectiv | foggyperspective.com (blog)}