|
|
Posted by vicyankees on 04/18/06 08:19
I am creating a report that has call duration and if i run it over a
multi-day span the duration is limited to 24 hours and starts over at
zero. is there a way to not limit hours?
I am usign the following in my select statement:
convert(varchar(12), dateadd(s,
SUM(ISNULL(Calls.OutgoingCallDuration,0)), '19900101'), 108) AS
[Outgoing Call Duration]
Navigation:
[Reply to this message]
|