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 .
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.
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: Dim startDate As DateTime = DateTime.Now Dim endDate As DateTime = DateTime.Now.AddMonths(20) Dim totmonths As Integer = DateDiff(DateInterval.Month, startDate, endDate) Response.Write(totmonths) and C# For this you have to Reference to System.Data.Linq PHP: DateTime startDt = DateTime.Now; DateTime endDt = DateTime.Now.AddMonths(20); int tot = System.Data.Linq.SqlClient.SqlMethods.DateDiffMonth(startDt, endDt); Response.Write(tot); I hope this has solved your querry...and next time be nice to post the description of the problem in the post..