Re: cfoutput and grouping

2002-07-14 Thread Joseph Thompson
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

RE: cfoutput and grouping

2002-07-14 Thread Whiterod, David (PLNSA)
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

RE: cfoutput and grouping

2002-07-14 Thread Matthew Walker
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

RE: cfoutput and grouping

2002-07-14 Thread Timothy Heald
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