Q&A for Salesforce administrators, implementation experts, developers and anybody in-between
SELECT MONTH(CreationDate) Month, DAY(CreationDate) Day, COUNT(*) PostCount FROM Posts WHERE CreationDate BETWEEN '2012-11-01' AND '2012-11-30' GROUP BY MONTH(CreationDate), DAY(CreationDate) ORDER BY MONTH(CreationDate), DAY(CreationDate)