Grouping results by month

[tariqali]

Hello,

I have a query that pulls results from the database and group them by week. I have a weekstart date and weekending date in the results table. This report will have Year to date results and I wanted to break the results to display by Month. How can I achive this?

Thanks for the help!

[websiteideas]

What does the following output?

<cfquery name="rsShowDate" datasource="dbname"> SELECT TheDate FROM tblname GROUP BY TheDate ORDER BY TheDate ASC </cfquery>

<cfoutput query="rsShowDate" group="TheDate">
#rsShowDate.TheDate#
#LSDateFormat(rsShowDate.TheDate,'MMMM YYYY')#
</cfoutput>