Since I hate Blogger's reports, ahem, lack of reports, I decided to try out the Google Bogger API to get what I wanted. Specifically, I want a report of posts by month.
I know this is possible as I've seen this on multiple blogs in the Archive or Categories section:
So instead of manually running an anonymous block to populate a table which I will then query, I decided to throw into Apex to make my life a little bit easier.
I create an application with a blank page and create my first item, P1_FROM_DATE. I decided to use a Date Picker (use item format mask):
I then created an item, P1_DATE_FORMAT, with the YYYY-MM-DDTHH24:MI:SS set as the source. When I created the Data Picker, I was thinking there would be some place to select the item, but there wasn't. So I opted to enter the format in the Source section:
Then I ran the page and clicked on the little calendar icon, only to see this:
Off to the Application Express forum and I read a few posts mentioning bad formats.
So I removed the "weird" YYYY-MM-DDTHH24:MI:SS format and voila!
That'll teach me to try something new when I'm rusty.
As a small aside, the date format, is the RFC 3339 format, according to the Google documentation.