Grouping problem on dates

[Jake McKee]

Hi there, I'm trying to create a list of dates like this:

Jan 03 (19 records)

Feb 03 (34 records)

March 04 (2 records)

Right now, I'm using this query:

<CFQUERY name="findDates2" datasource="#ATTRIBUTES.datasource#">

            SELECT DatePart('m', entryDate) as xMonth, count(*) as
xcount

            FROM entries

            WHERE entryStatus = 1

            GROUP BY DatePart('m', entryDate)

</CFQUERY>

And it works like a champ. for one year. Of course, the Jan 03 and Jan
04 records will get lumped in the same group.bad.

Any ideas on how to make this work?

Thanks!
Jake

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---