You should be able to do a simple group on the date:
SELECT
Format(YourDate,'') AS GroupedDate
GROUP BY
GroupedDate
http://cfhub.com/forum//index.cfm?FuseAction=Thread&TopicID=2399
> Hi,
>
> What is the best way to group by months for a query that contains full
(day,
> month, year) dat
PROTECTED]]
Sent: Monday, 15 July 2002 10:26 AM
To: CF-Talk
Subject: RE: cfoutput and grouping
What DB are you using?
Tim
-Original Message-
From: Whiterod, David (PLNSA) [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 14, 2002 8:49 PM
To: CF-Talk
Subject: cfoutput and grouping
Hi
If you can'rt change the query, I would do exactly what you are
thinking, q of q with CreateDate(Year(startDate), Month(startDate), 1)
> -Original Message-
> From: Whiterod, David (PLNSA) [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 15 July 2002 12:49 p.m.
> To: CF-Talk
> Subject: cfoutput
What DB are you using?
Tim
-Original Message-
From: Whiterod, David (PLNSA) [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 14, 2002 8:49 PM
To: CF-Talk
Subject: cfoutput and grouping
Hi,
What is the best way to group by months for a query that contains full (day,
month, year) dates?
T
4 matches
Mail list logo