I need some help with a query to count posts made in a certain year and month.
I was thinking of something like
The data I have to work with is a string value formated like this: 201204
WHERE time_field > ... AND time_field < ...
It's formated like Year Month so this would be 2012 April.
So I was kind of wondering how can I get this to work.
I'm trying to the count how maney posts where made in the year 2012 in the month April.
I can convert the string year and date by php using strtotime('201204' . '01');