Calculating time interval (from a string)
I want to summarize a column with time intervals (total duration of conversations). Data type of the field in my database is string. I tried to convert string to datetime, but I always got same format: 1900-01-01 hh:mm:ss. I tried to convert with 108 or
8, it doesn't matter what I write inside the convert function, 1900-01-01 is still there. I can get ride of 1900-01-01 if I change placeholder properties (formatting number and date) in the report but I still can't summarize the column. I even tried with following
expression =System.TimeSpan.FromTicks(Sum(Fields!Total_Duration_of_Conversation.Value)) but I just got #error. I even tried to write some UDF in the database but I still can't use SUM either in the query or in the report. Any suggestions how to solve
this, I just wanna have total and grand total, it doesn't matter if I do it in my database or in the report. Please help! :)
July 30th, 2011 4:35am