I have a list records that have start and end dates (7/1/1-7/31/11, 8/1/11-8/31/11...). As there are multiple records with the same start and end dates I want to group them in the query but have no clue how to do that.
Any help would be greatly appreciate!
The Query Builder has the "Grouping" functions, which will allow you to group by date.
However, if the date includes the time, it may not do what you want. A quick and dirty way to accomplish grouping by date is to add an expression to your query the uses the "Format" function to convert the date to something you want to group by.
For example, if I want to group by week, use this as your field:
The format function will convert the date to a string, in this case "2012-12" (for the 12th week of 2012).
There is lots of help on this and other date handling functions in this forum and on the web. Good luck.