I am taking the planned start/end dates and actual start/end dates and calculating the variance and I am ending up with results like 3.00:00:00. I'd like to convert it to an integer or string so I can add "days" after it. Formatting the textbox to a number doesn't help. I tried Cint() but that didn't work either. Can anyone tell me how to convert 3.00:00:00 into 3 please?
MS VS 2010
MS SQL Server 2008 R2
= ReportItems!ActualStartDate.Value - ReportItems!PlannedStartDate.Value
= CDate(ReportItems!PlannedEndDate.Value) - Cdate(ReportItems!ActualEndDate.Value)