Grouping by Month and by Year

kawprice60

New member
Local time
Yesterday, 22:14
Joined
May 30, 2012
Messages
5
I have an issue where I need to group data in a report by month and by year. Can someone help me?

I have tried the following in the report
=format ([date], "yyyy",0,0)
with the data I want by year

with
-format ([date],"mmmm yyyy",0,0)
with the same data by month

the year and the month data are the same. Any help is much appreciated.
 

Users who are viewing this thread

Back
Top Bottom