SELECT ID,Name,[Start date],[End date], DATEDIFF( DD, [Start date],[End date]) DiffInDaysFROM tableName
Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif
DateTime StartDt = Convert.ToDateTime(gdvEmp.Rows[0].Cells[2].Text); DateTime EndDt = Convert.ToDateTime(gdvEmp.Rows[0].Cells[3].Text); TimeSpan span = EndDt.Subtract(StartDt); txtGrdData.Text = span.Days.ToString(); // You can get the difference in hours, days, years and so on
Login to post response