Summarizing based on Date

[#1]

I have a date field in my database (MM/DD/YYYY) and would like to be able to summarize by year and or month. How can I display just month in the 'X" axis of a chart?

Thanx

[#2]

This works but it doesn't group the data in the list box. I am still trying to figure out how to get the data to roll up by Month, Year and Month/Year

[#3]

put your code here to check the problem

[#4]

Load Order__c,
Month(Billing_Date__c) as Month,
Year(Billing_Date__c) as Year
Resident Order__c
Group by Month, Year;

[#5]

The code is perfect for me, try this.

Load Order__c,
Month(Billing_Date__c) as Month,
Date(Billing_Date__c,'MM/YYYY') as MonthYear1,
MonthName(Billing_Date__c) as MonthYear2,
Year(Billing_Date__c) as Year
Resident Order__c
Group by Month, Year;