Loading

converting integert to date format

converting integert to date format

Vamsi Krishna

Vamsi Krishna

11y1kLearn iOS Programming

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jean-Claude Colette11y ago
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 < 0) ? 0 : 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) <= laterDate)
{
remaining_months++;
}
number_month += remaining_months - 1;
0
Francis Susaimichael11y ago
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!

0