range between dates...

Question

i want to get days,months,years in between two dates(two textboxes(datepickers)) in mvc..can anyone help....

Vulpes · Answer

The TimeSpan structure cannot show the difference between two dates in years, months and days. However, the following C# method can do this: public static void DateDiff(DateTime dt1, DateTime dt2, out int years, out int months, out int days) { int dv1 = dt1.Year * 372 + (dt1.Month - 1) * 31 + dt1.Day - 1; int dv2 = dt2.Year * 372 + (dt2.Month - 1) * 31 + dt2.Day - 1; days = Math.Abs(dv2 -dv1); months = days / 31; years = months / 12; months = months % 12; if (dv2 >= dv1) { if (dt2.Day >= dt1.Day) { days = dt2.Day - dt1.Day; } else { int dim = DateTime.DaysInMonth(dt1.Year, dt1.Month); days = dt2.Day + dim - dt1.Day; } } else { if (dt1.Day >= dt2.Day) { days = dt1.Day - dt2.Day; } else { int dim = DateTime.DaysInMonth(dt2.Year, dt2.Month); days = dt1.Day + dim - dt2.Day; } } } For example: DateTime dt1 = new DateTime(2000, 2, 10); // 10 February 2000 DateTime dt2 = DateTime.Today; // 2 April 2014 int years, months, days; DateDiff(dt1, dt2, out years, out months, out days); string result = String.Format( "{0} years, {1} months, {2} days", years, months, days); Response.Write(result); The output is: 14 years, 1 months, 21 days The method always returns the positive difference between two dates and so it doesn't matter in what order they are presented to it. In your case the parameters will, of course, be: DateTime dt1 = DateTimePicker1.Value.Date; DateTime dt2 = DateTimePicker2.Value.Date;