<cfloop> over the query and do your dateadd to the date field before you
feed the query to cfgraph

----- Original Message -----
From: "Jeff Beer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 3:00 PM
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
>
> 
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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

Reply via email to