So, I am using Drupal 7.19 and Views 3.5. For some reason, I can not group by a date field no matter what!
I created a simple view that displays the number of nodes that have been published per month. As such, I selected the
Post date fields, enable aggregation, count on
Nid and group on
No grouping. There is a record being pulled for every single node in the database, as if the grouping is being completely ignored.
If you run the SQL statement Views generates on the database, you also get a complete result set but that is obviously because the UNIX time stamps themselves are different, if even my a second. That's expected. How can I get Views to group by a formatted value, such as a Month, Year, etc, to avoid this problem?
I tried everything suggested here and elsewhere - I already had the
RDF module disabled, emptied cache, added a new date format, strip white space from the date field ,I even disabled the
Date module for fear it was conflicting with it.
This is driving me absolutely crazy! Would appreciate any suggestions. Thanks.