setting expression in Computed Column

joyce_j

Hi,
if we have two columns in database and they are the start time and end time of a process.
To obtain the start time we may write:
ComputedColumn.setExpression("dataSetRow["" + startTime + ""]");
and to display the end time,
ComputedColumn.setExpression("dataSetRow["" + endTime + ""]");

Instead of displaying these two timestamps, if we want to display the difference between them in the report how can we modify above statements?

Thanks!
Joyce

mwilliams

Hi Joyce,

You could probably use the DateTimeSpan.seconds() function to figure the seconds between the two time stamps, then create a new date object with that seconds value. If you format the output to be shown in 24hr time, you should get the elapsed time.

Hope this helps.