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 que
SENIOR ANALYST
SBC SERVICES, INC
Tel: 858.886.3878
Fax: 858.653.6763
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 12:01 PM
To: CF-Talk
Subject: dateadd with grouped query and cf
Adam, Dave, and anyone who answers before this hits the list - thanks for
the assist!!
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 3:13 PM
To: CF-Talk
Subject: RE: dateadd with grouped query and cfgraph
Not exactly sure how your db
bject: 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
> Sent: Thursday, March 21, 2002 2: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
> 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?
You could modify the dat
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
__
7 matches
Mail list logo