1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Difference between dates

Discussion in 'ASP.NET' started by vidyadeb, May 8, 2012.

  1. vidyadeb

    vidyadeb New Member

    Please advice my two get diffrence of two dates .Please also check attach. Please suggest this also or can send total different way doing it .

    Attached Files:

  2. shabbir

    shabbir Administrator Staff Member

    You are expecting too much by attaching your issue. You want someone to download solve and then give back to you where as you have not taken the pain to explain the issue inline.
  3. bzforum

    bzforum New Member

    I took the pain to open the doc and see what the OP needed...

    He needs to get a Difference between 2 dates...a Start Date and the End Date but he wants to count it as months..

    that means if the user has selected 01 June 2012 to 01 Aug 2012 the result should be 2 Months..

    And here is the solution for it in VB.NET..

            Dim startDate As DateTime DateTime.Now
            Dim endDate 
    As DateTime DateTime.Now.AddMonths(20)

    Dim totmonths As Integer DateDiff(DateInterval.MonthstartDateendDate)

    and C#

    For this you have to Reference to System.Data.Linq
            DateTime startDt DateTime.Now;
    DateTime endDt DateTime.Now.AddMonths(20);
    int tot System.Data.Linq.SqlClient.SqlMethods.DateDiffMonth(startDtendDt);
    I hope this has solved your querry...and next time be nice to post the description of the problem in the post..
    shabbir likes this.

Share This Page