How to calculate the difference between 2 dates in days, months and years

  • Thread starter Thread starter Alexander Vasilevsky
  • Start date Start date
I'd start with the TimeSpan object.

http://msdn2.microsoft.com/en-us/library/system.timespan.totaldays.aspx







- Show quoted text -
Click to expand...

Try This

System.DateTime FirstDate
System.DateTime SecondDate
System.DateTime OriginalDate
int year,month,day,monthDays;
year=month=day=monthDays=0;

OriginalDate=FirstDate;
monthDays=System.DateTime.DaysInMonth(OriginalDate.Year,OriginalDate.Month);


year=FirstDate.year-SecondDate.Year
if(SecondDate.DayOfYear<FirstDate.DayOfYear)
{
year--;
}


FirstDate=new
System.DateTime(SecondDate.Year,FirstDate.Month,FirstDate.Day);
month=Math.Abs(FirstDate.Month-((SecondDate.Month<FirstDate.Month) ?
12+FirstDate.Month : FirstDate.Month));

if(SecondDate.Day<FirstDate.Day)
{
month--;
day=monthDays-FirstDate.Day-SecondDate.Day;
}
else
{
day=SecondDate.Day-FirstDate.Day;
}
 
Try This

System.DateTime FirstDate
System.DateTime SecondDate
System.DateTime OriginalDate
int year,month,day,monthDays;
year=month=day=monthDays=0;

OriginalDate=FirstDate;
monthDays=System.DateTime.DaysInMonth(OriginalDate.Year,OriginalDate.Month)-;

year=FirstDate.year-SecondDate.Year
if(SecondDate.DayOfYear<FirstDate.DayOfYear)
{
year--;

}

FirstDate=new
System.DateTime(SecondDate.Year,FirstDate.Month,FirstDate.Day);
month=Math.Abs(FirstDate.Month-((SecondDate.Month<FirstDate.Month) ?
12+FirstDate.Month : FirstDate.Month));

if(SecondDate.Day<FirstDate.Day)
{
month--;
day=monthDays-FirstDate.Day-SecondDate.Day;}

else
{
day=SecondDate.Day-FirstDate.Day;



}- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -
Click to expand...

Sorry:::::
System.DateTime FirstDate
System.DateTime SecondDate
int year,month,day,monthDays;
year=month=day=monthDays=0;

monthDays=System.DateTime.DaysInMonth(FirstDate.Year,FirstDate.Month);


year=FirstDate.year-SecondDate.Year
if(SecondDate.DayOfYear<FirstDate.DayOfYear)
{
year--;
}

month=Math.Abs(FirstDate.Month-((SecondDate.Month<FirstDate.Month) ?
12+FirstDate.Month : FirstDate.Month));

if(SecondDate.Day<FirstDate.Day)
{
month--;
day=monthDays-FirstDate.Day+SecondDate.Day;
}
else
{
day=SecondDate.Day-FirstDate.Day;
}
 
Sorry:::::
System.DateTime FirstDate
System.DateTime SecondDate
int year,month,day,monthDays;
year=month=day=monthDays=0;

monthDays=System.DateTime.DaysInMonth(FirstDate.Year,FirstDate.Month);

year=FirstDate.year-SecondDate.Year
if(SecondDate.DayOfYear<FirstDate.DayOfYear)
{
        year--;

}

month=Math.Abs(FirstDate.Month-((SecondDate.Month<FirstDate.Month) ?
12+FirstDate.Month : FirstDate.Month));

if(SecondDate.Day<FirstDate.Day)
{
        month--;
        day=monthDays-FirstDate.Day+SecondDate.Day;}

else
{
        day=SecondDate.Day-FirstDate.Day;



}- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -
Click to expand...
I fired that off, yesterday. You'll have to tweak it. But that is
the idea!
 
Back
Top