I have a table that has data with entry dates back through the years. Is there a way to sort data into year/month order? So if I am counting the number of transactions per day I would get data returned like this?
Month Day Count
1 1 56
1 2 60
1 3 72
I don't have a sample table to work off of, I have just been wondering if there was an efficiant way to accomplish this.