[font="Verdana"]

Select category, count(*) From {Table}

Where createdDate Between {start date} And {end date}

Group By category

confirm on this.

Mahesh

[/font]