I figured it out - sorry for the bother. here's the fix: <cfquery ...> blah blah blah...
DATEPART(hh, DATEADD(hh, 2, who.ActionDateTime)) AS HOURS GROUP BY DATEPART(hh, DATEADD(hh, 2, who.ActionDateTime)) blah blah blah </cfquery... -----Original Message----- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 3:01 PM To: CF-Talk Subject: dateadd with grouped query and cfgraph I run a graph on a server in a different time zone. I'd like to modify the times (hour only) by adding two hours. However, the query is grouped by day and hour, then fed into CFGRAPH. Anyone know if this can be done without modifying the data in the table? Thanks! Jeff ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
