View OutageDate without any date formating. If it's different for each row, including seconds, it'll not group as you want.
I see you're formatting in the query, does the 104 mask include seconds? Oh and why the double call of CONVERT? Adrian -----Original Message----- From: John Beirne [mailto:[EMAIL PROTECTED] Sent: 22 July 2008 21:35 To: CF-Newbie Subject: Grouping not working with dates I'm working on a report in CFML that should group records by date, something like: Tuesday, July 1, 2008 When: July 1 from 8:00 AM until 8:12 AM Location: Chicago Business Unit: WLS Priority: 1, Ticket23 Brief Description: Hanes tidy whiteys Cause: 'Cause I said so Impact: Wrench Resolution: We don't wanna change the world When: July 1 from 9:00 AM until 9:12 AM Location: New Zealand Business Unit: Foo Priority: 1, Ticket34 Brief Description: Glibby glab Cause: Because we like you! Impact: Ouch Resolution: Nafr nafr Wednesday, July 2, 2008 When: July 2 from 8:00 AM until 8:12 AM Location: Berwyn Business Unit: CTU Priority: 5, Ticket24 Brief Description: lsdjfkjds Cause: XXXXXXXXX Impact: XXXXXXXXX Resolution: XXXXXXXXXXXXXXX What's happening is the dddd, mm/dd/yyyy are appearing for every record. I'm attaching the pertinent section of code. Thanks for any help! Attach Code <cfquery name ="qryWIRDate" datasource="#Session.PMDBDataSource#"> SELECT 'Date' as ReportGroup , convert(datetime, convert(varchar, SCTicket.OutageStart, 104),104) as OutageDate , SCTicket.OutageStart , SCTicket.OutageEnd , '1' as SortField , Pri.Abbrev , SCTicket.SCTicket , SCTicket.IssueTitle , SCTicket.RootCause , SCTicket.Impact , SCTicket.Resolution , SCTicket.ResultOfChange , CASE WHEN SCTicket.ResultOfChange = '1' THEN ', Result Of Change' END as ROCIndicator FROM tblSCTicket SCTicket INNER JOIN tblPriorities Pri ON SCTicket.PriorityID = Pri.PriorityID WHERE (SCTicket.SCDateEntered between '#Start#' and '#End#') AND SCTicket.SCTicket = '#aryDistTckts[i]#' ORDER BY OutageStart, SCTicket </cfquery> <cfoutput query="qryWIRDate" group="OutageDate"> <P></P> #DateFormat(OutageDate, "dddd, mm-dd-yy")# <table class="ticket"> <tr> <th>When:</th> <td>#DateFormat(OutageStart, "mm/dd/yy")# from #TimeFormat(OutageStart, "h:mm tt")# until #TimeFormat(OutageEnd, "h:mm tt")#</td> </tr> <tr> <th>Priority:</th> <td>#Abbrev#, #SCTicket# #ROCIndicator#</td> </tr> <tr> <th>Brief Description:</th> <td>#IssueTitle#</td> </tr> <tr> <th>Cause:</th> <td>#RootCause#</td> </tr> <tr> <th>Resolution:</th> <td>#Resolution#</td> </tr> </table> </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3854 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
