How to calculate months between two dates

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

i have start date and end date in my website

how to calculate no of without count of days for example

Start date 30/5/2015
End date 1/6/2015

in this case also i want to show 2 months May-2015 and june-2015

my code is

it calculate total days between dates,

C#

protected void txtStartDate_TextChanged(object sender, EventArgs e)
   {
       string inputString = txtStartDate.Text;
       DateTime dt = DateTime.ParseExact(inputString, "yyyy/MM/dd", CultureInfo.InvariantCulture);
       dt = dt.AddMonths(Convert.ToInt32(txtNoOfMonths.Text));
       txtEndDate.Text = dt.ToString("yyyy/MM/dd");


       DateTime Date1 = Convert.ToDateTime(txtStartDate.Text);
       DateTime Date2 = Convert.ToDateTime(txtEndDate.Text);
       int DayDiff = (Date2.Date - Date1.Date).Days;
       Label1.Text = "Total days"+" "+(DayDiff.ToString());
        }

how to calculate months

Posted 29-May-15 23:34pm

Member 11382784

Updated 23-Apr-23 1:04am

RajeeshMenoth

v2

Add a Solution

Comments

Michael_Davies 30-May-15 5:49am

Use DateDiff and add 1...

Dim date1, date2 As Date

date1 = "30/5/2105"
date2 = "1/6/2105"

Dim m As Integer

m = DateDiff(DateInterval.Month, date1, date2) + 1

6 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Santhosh Babu Mahimairaj · Answer 1 · 2015-05-29T23:50:00

SQL

Assuming the day of the month is irrelevant (i.e. the diff between 2011.1.1 and 2010.12.31 is 1), with date1 > date2 giving a positive value and date2 > date1 a negative value

((date1.Year - date2.Year) * 12) + date1.Month - date2.Month
Or, assuming you want an approximate number of 'average months' between the two dates, the following should work for all but very huge date differences.

date1.Subtract(date2).Days / (365.25 / 12)
Note, if you were to use the latter solution then your unit tests should state the widest date range for which your application is designed to work with and validate the results of the calculation accordingly.

OriginalGriff · Answer 2 · 2015-05-29T23:57:00

Solution 2

See here: Working with Age: it's not the same as a TimeSpan![^]

Posted 29-May-15 23:57pm

OriginalGriff

Sujith Karivelil · Answer 3 · 2015-05-30T00:10:00

You can use LINQ to find this consider the following code:

C#

string StartDate="3/15/2015";
           string EndDate = "5/6/2015";
           DateTime ActualStartDate = DateTime.Parse(StartDate);
           DateTime ActualEndDate = DateTime.Parse(EndDate);
           ActualEndDate = new DateTime(ActualEndDate.Year, ActualEndDate.Month, DateTime.DaysInMonth(ActualEndDate.Year, ActualEndDate.Month));
           var diff = Enumerable.Range(0, Int32.MaxValue)
                                .Select(e => ActualStartDate.AddMonths(e))
                                .TakeWhile(e => e <= ActualEndDate)
                                .Select(e => e.ToString("MMMM"));

It gives you output as {"March","April","May"}

psima · Answer 4 · 2015-05-31T23:47:00

Please use the below function in your code and show months between two dates :-

C#

private string getMonthsBetweenTwoDates(DateTime Date1, DateTime Date2)
    {
        var diff = Enumerable.Range(0, Int32.MaxValue)
                     .Select(e1 => Date1.AddMonths(e1))
                     .TakeWhile(e1 => e1 <= Date2)
                     .Select(e1 => e1.ToString("MMM/yyyy")).ToList();

        return  string.Join(",", diff.ToArray()).ToString();
    }

Maddy selva · Answer 5 · 2015-06-03T18:53:00

Solution 5

simply using this Query and get month difference between two dates.

SQL

Declare @Start DateTime
Declare @End DateTime

Set @Start = '5/30/2015'
Set @End = '6/1/2015'

Select DateDiff(Month, @Start, @End + 1)

Posted 3-Jun-15 18:53pm

Maddy selva

Updated 3-Jun-15 18:54pm

Member 2105405 · Answer 6 · 2023-04-23T01:04:00

DateTime fromDt = DateTime.Parse("18-12-2022");
                DateTime toDt = DateTime.Parse("10-02-2021");
                int fromMon = fromDt.Month;
                int fromYear = fromDt.Year;
                int toMon = toDt.Month;
                int toYear = toDt.Year;
                if (toMon < fromMon)
                {
                    toMon += 12;
                    toYear--;
                }
                int months = ((toYear - fromYear) * 12 + toMon - fromMon) + 1;

How to calculate months between two dates

6 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Solution 6

Add your solution here

Preview 0