Home Forums Reporting Services Reporting Services 2008 Development date difference average question RE: date difference average question<!-- 864 -->
venus.pvr
SSCarpal Tunnel
Points: 4813
More actions
August 20, 2014 at 7:34 am
#1739570
Hers is the expression I used to get the average which works:
Format(DateAdd("s",avg(DateDiff(DateInterval.Second,Fields!BeginDate.Value,Fields!EndDate.Value)), "00:00:00"),"HH:mm:ss")
Thank you All