Difference between dates

vidyadeb's Avatar, Join Date: May 2012
Newbie 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
File Type: doc Doc_Deff_date_try.doc (30.5 KB, 4 views)
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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.
bzforum's Avatar, Join Date: May 2012
Go4Expert 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..

PHP Code:
        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
PHP Code:
        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..