Grouping by Month and by Year (1 Viewer)

kawprice60

New member
Local time
Today, 09:27
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

Top Bottom