converting integert to date format

Question

Hi i have month and year like int lastpaidyear = Convert.ToInt32(lastpaidmonth.Rows[0][1].ToString()); ex:8 int lastpaismonth = Convert.ToInt32(lastpaidmonth.Rows[0][2].ToString());ex:2012 and int selectmonth = Convert.ToInt32( ddlmonth.SelectedValue.ToString());ex:10 int selectyear = Convert.ToInt32( ddlyear.SelectedValue.ToString());ex:2015 now i want total month ? please help me

Jean-Claude Colette · Answer

Hi to be sure to have the correct number of months I make an adjustment at the end: DateTime first = new DateTime(2015 1 31); DateTime second = new DateTime(2015 10 21); DateTime earlierDate = (first > second) ? second.Date : first.Date; DateTime laterDate = (first > second) ? first.Date : second.Date; int number_month = (laterDate - earlierDate).Days/31 - 2; number_month = (number_month //default rounding of the number of plain month completely included between the 2 dates earlierDate = earlierDate.AddMonths(number_month); int remaining_months = 1; while (earlierDate.AddMonths(remaining_months) { remaining_months++; } number_month += remaining_months - 1;

Francis · Answer

Simply you want to find the months between 2 dates if so try this: int lastpaidyear = 2012; int lastpaismonth = 8; int selectmonth = 10; int selctyear = 2015; DateTime first = new DateTime(lastpaidyear lastpaismonth 1); DateTime second = new DateTime(selctyear selectmonth 1); int totalMonths = second.Subtract(first).Days / (365 / 12); Hope this helps!