How to get months difference between two dates in c#

Question

I have two date fields where i need to caluculate difference in months between those two dates how can i do this.Below is my formula
(start.Year * 12 + start.Month) - (end.Year * 12 + end.Month);
Expected Result
Start Date End Date Need to get output as
08/28/2019 09/02/2019 1
06/01/2019 09/02/2019 4
01/02/2019 03/02/2019 3
01/02/2019 03/05/2019 3

Amit Mohanty · Answer

Hey try this public   struct  DateTimeSpan   {        public   int  Years {  get ; }        public   int  Months {  get ; }        public   int  Days {  get ; }        public   int  Hours {  get ; }        public   int  Minutes {  get ; }        public   int  Seconds {  get ; }        public   int  Milliseconds {  get ; }           public  DateTimeSpan( int  years,  int  months,  int  days,  int  hours,  int  minutes,  int  seconds,  int  milliseconds)       {           Years = years;           Months = months;           Days = days;           Hours = hours;           Minutes = minutes;           Seconds = seconds;           Milliseconds = milliseconds;       }           enum  Phase { Years, Months, Days, Done }           public   static  DateTimeSpan CompareDates(DateTime date1, DateTime date2)       {            if  (date2          {               var sub = date1;               date1 = date2;               date2 = sub;           }              DateTime current = date1;            int  years = 0;            int  months = 0;            int  days = 0;              Phase phase = Phase.Years;           DateTimeSpan span =  new  DateTimeSpan();            int  officialDay = current.Day;               while  (phase != Phase.Done)           {                switch  (phase)               {                    case  Phase.Years:                        if  (current.AddYears(years + 1) > date2)                       {                           phase = Phase.Months;                           current = current.AddYears(years);                       }                        else                        {                           years++;                       }                        break ;                    case  Phase.Months:                        if  (current.AddMonths(months + 1) > date2)                       {                           phase = Phase.Days;                           current = current.AddMonths(months);                            if  (current.Day                              current = current.AddDays(officialDay - current.Day);                       }                        else                        {                           months++;                       }                        break ;                    case  Phase.Days:                        if  (current.AddDays(days + 1) > date2)                       {                           current = current.AddDays(days);                           var timespan = date2 - current;                           span =  new  DateTimeSpan(years, months, days, timespan.Hours, timespan.Minutes, timespan.Seconds, timespan.Milliseconds);                           phase = Phase.Done;                       }                        else                        {                           days++;                       }                        break ;               }           }               return  span;       }   }
DateTime compareTo = DateTime.Parse( "02/01/2019" );   DateTime now = DateTime.Parse( "02/03/2019" );   var dateSpan = DateTimeSpan.CompareDates(compareTo, now);   Console.WriteLine( "Months: "  + dateSpan.Months);
Or try this
DateTime date1 = DateTime.Parse( "02/03/2019" );   DateTime date2 = DateTime.Parse( "02/01/2019" );      Console.WriteLine(((date1.Year - date2.Year) * 12) + date1.Month - date2.Month);

Amit Gupta · Answer

var month = (endDate - StartDate).TotalMonths;

Wahid Bitar · Answer

I've answered about this in https://stackoverflow.com/a/65284425/105445 to get the exact fractions of the months like what we have in the `TimeSpan.TotalDays` for example. for example what is the result of total months between `20-01-2021` and `20-03-2021`? I guess it should be `2.0xx`, but if you considered Feb as 30 days, you'll get a different answer "`1.8xx` or something" So I've done the calculation according to the days in each month between the selected dates. - First I've got the list of days between the selected two dates - then I grouped them by month and did the calculation the code:     public static double GetTotalMonths(this DateTimeOffset firstDate, DateTimeOffset thru) { var days = firstDate.EachDayTill(thru).ToList(); return days.GroupBy(d => new {d.Month, d.Year,}) .Sum(g => (g.Count() * 1.00) / (DateTime.DaysInMonth(g.Key.Year, g.Key.Month) * 1.00)); } public static IEnumerable EachDayTill(this DateTimeOffset from, DateTimeOffset thru) { for (var day = new DateTimeOffset(from.Date, TimeSpan.Zero); day.Date yield return day; }

Dhara Patel · Answer

Hi,  Try this bellow code. I have written using your first example and it gave the correct result.      Ans:1

Mageshwaran R · Answer

Hi, Try this code:   ((date1.Year - date2.Year) * 12) + date1.Month - date2.Month

Jignesh Kumar · Answer

Hello,   Please try below link, https://forums.asp.net/t/1751406.aspx?Difference+between+two+dates+in+Years+Month+Days+

Priyanka Jain · Answer

Try using below code in C# ((date1.Year - date2.Year) * 12) + date1.Month - date2.Month     For more, you can refer below link,   https://stackoverflow.com/questions/4638993/difference-in-months-between-two-dates   https://dotnetcodr.com/2015/10/30/calculate-the-number-of-months-between-two-dates-with-c/

Test · Answer

but it should be done using c# or jquery

Priyanka Jain · Answer

try this it will give you exact output you want    SELECT CEILING(DATEDIFF(DAY, startdate, enddate) / 29.436875E) FROM #temp

Test · Answer

'01/02/2019','03/02/2019' should give output as 3 not 2 remaining all are correct