Group by month when base date field is at daily detail

[SmellyMelly]

I would like to create a report where the data is grouped by month by division. My data is at a daily level. When I use the grouping function in the report however, the results is one group by division, with several entries per month.

I thought to create a new field in a query to extract the month from the date format (which is a medium date), and group by that field, then create the report. But I don't know the expression to do that. Does anyone know how to do this?

thanks!

 

[GHolden]

you can get just the month from..

Month(Date) There are two ways to write error-free programs; only the third one works.

 

[SmellyMelly]

Thanks! the query worked with that as a GroupBy, and a custom date format in the field properties. Now to get it in the report!